Forum Discussion
Showing Average Percentage per Month Over Time in Pivot Table/Chart
Now it's available, thank you.
Number in your cells were texts, even if now General format is applied to such cells. Freen triangle means
In PivotTable you may only count texts. Thus you need numbers. For that to re-enter values; or copy any empty cell, select cells in question, Paste, Paste Special, Add, Ok.
With that you may aggregate any numeric field as average or whichever aggregation you need.
Google doesn't give access to the file, could you share it as Excel file by another way?
Hi, sorry about that! I tried OneDrive instead. Does that work? I tried uploading the Excel sheet directly to this forum, but I got a message saying the file type was unsupported, which seems strange. I was working in the "WIP.User Satisfaction Survey OT" tab, by the way, trying to use the "Overall Rating %" field to get the percentages of each survey.
Now it's available, thank you.
Number in your cells were texts, even if now General format is applied to such cells. Freen triangle means
In PivotTable you may only count texts. Thus you need numbers. For that to re-enter values; or copy any empty cell, select cells in question, Paste, Paste Special, Add, Ok.
With that you may aggregate any numeric field as average or whichever aggregation you need.
Thanks so much, you're a lifesaver! This explains a lot. xD
I'm running into one more problem. I formatted my numbers as pictured below to make it so that the percentage sign shows, but whenever I choose a different value to filter by, my labels lose their formatting. This was happening too with their color, glow, and any other changes I made to them. Am I not doing this correctly? Aren't I supposed to edit the color, formatting, etc. in this side box? Or is there somewhere I'm supposed to edit the base "template" somehow?
