How can I add a row that shows the total number for each column in my pivot table?
Great, thank you!
There will be option of Show Total for each Dimension in Column section.. Enable that option
Thank you, I found it!
Can I also get a total at the bottom of each column?
No, you can't do that.
But if you want to change the Total (how it's calculated) ; in the expression do:
if (dimensionality()=0,Avg(Sales), your expression)
It's not what you asked for but I thought It couuld be helpful for another time !
Retrieving data ...