Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I add a row that shows the total number for each column in my pivot table?
Thanks!
There will be option of Show Total for each Dimension in Column section.. Enable that option
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?
Great, thank you!
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 !