Total in pivot table

[#1]

Hello,

I need to show totals in a pivot table, where “carrier name” and “year” are the dimensions and the sum of #trasported passangers is the expression. The year dimension is shown horizontally (on top) like in the image below.

I tried to check the flag “Show partial sum” in the properties but it doesn’t work.

How can I do?

Thanks

[sunny_talwar · Accepted solution]

Did you try scrolling all the way to the bottom to see if the Totals are available there?

If you want them to be visible at all times, may be put them on the top from the presentation tab

[#3]

Thanks.

I tried to check “Show partial sums” again and now scrolling I can see the totals.

I was sure that they weren’t visible also scrolling down to the bottom. I don’t know.

Is there a way to show the totals at the bottom also without scrolling?

[sunny_talwar]

I don't think that is possible, but there might be a work around or a macro.