Dear All
Is it possible to show total of the average values in a PivotTable column?
In example below, Grand Total to show 412 instead of 13:
PT2.png
Thank you.
Joseph
Dear All
Is it possible to show total of the average values in a PivotTable column?
In example below, Grand Total to show 412 instead of 13:
PT2.png
Thank you.
Joseph
If you load the data to the data model, then you can use a couple of measures to get the answer you want. Assuming your source table in the model is called Table1, your two measures would be:
AveQty: =AVERAGE(Table1[Qty])
SumAveQty: =IF(HASONEFILTER(Table1[Item Type]),[AveQty],SUMX(VALUES(Table1[Item Type]),[AveQty]))
Rory
Thanks rorya! I don't have PowerPivot, can I still use data model?
If you have Excel 2016, you should have Power Pivot available to you.
Unfortunately not with my version
Attachment 682590
I can't see that attachment.
The attachment basically says PowerPivot is not bundled to Excel 2016 standalone version.
Standalone 2016 should have PP available.
Thanks, but can't find it. Not in Customize Ribbon and not in Add-ins as well. Anywhere else I can look for it?
It would be in COM add-ins. It wasn't available in the original release of standalone Excel, but assuming your copy is up to date, you should have it available to the best of my knowledge.
Thanks, it is not in COM add-ins.
Are you sure you have standalone Excel, and not say Office Home edition? If you do, and it's up to date, you should have Power Pivot.
Let me check with my IT dept, thanks rorya!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks