Hi, If I use average to display values in powerpivot table, can Grand total show total of those averages? So if my "Sale of product X" is on average 5 in Day1 column, 6 in Day2 Column, Grand total column would show 11? Normal query would use Average function in Grand Total column too..., but I need to summarice values in pivot.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
GrandTotal to sumamry power pivot values
- Thread starter ajocius1
- Start date
