Total row in a Pivot table

[Anonymous]

Hi,

How can I add a row that shows the total number for each column in my pivot table?

Thanks!

[#2]

[shraddha_g · Accepted solution]

There will be option of Show Total for each Dimension in Column section.. Enable that option

[Anonymous]

Thank you, I found it!

[Anonymous]

Can I also get a total at the bottom of each column?

[Anonymous]

Great, thank you!

[OmarBenSalem]

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 !