Forum Discussion
Averages in a Pivot Table
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.
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?