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 Sergei,
Thank you for response, yes, my data is all within one calendar year, but it doesn't show correct result of average.
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
Hi Humayon,
IMHO, averages are calculated correctly if the mean average for the period. It is SUB of SoldQty / Count of SoldQty.
Do you mean it shall be average per day included days when nothing was sold?