Forum Discussion
Averages in a Pivot Table
Hi, I need to show the average sales per day and average sales per month but when I select "Summarize value by Average", it shows wrong number, any solution to this issue would be highly apprecia...
Hi Humayoan,
From your screenshot it's not clear are all your data within one calendar year or not. If yes, in general it shall show correct result. If not, in grouping you shall select bot month and year, otherwise it'll be average for selected month for all years in range.
- Hi Sergei,
Thank you for response, yes, my data is all within one calendar year, but it doesn't show correct result of average.Another reason could be if you have checked "Include filtered items in totals" (PowerPivot Options, Totals and Filters, Filters).
Apologies as I was on Eid Holidays, The option is not checked and the problem still exists, I have attached the excel file, if you can have a look and suggest the sollution, I would be highly thankful to you.
Regards
