Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
louisdch
Contributor III
Contributor III

Show total in the last row / last column in pivot table

Hi all,

 

Is there any way to show the total in the last row / last column in pivot table?

 

Best Regards,

Louis

5 Replies
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi Louis

Under the dimension, you can turn 'Show totals' on:

Pivot_Totals.png

Regards,

Mauritz

louisdch
Contributor III
Contributor III
Author

Hi Mauritz,

It would show on the first row/column in the pivot table.

I would like to total in the last row / last column in pivot table.

 

Best Regards,

Louis

Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi Louis

I also looked for that initially, but then found that the default is at the top of the table and could not change it (at least I could not find a way). Once I showed the dashboard to a client and explained that this would eliminate the need for scrolling to the bottom to see the totals he actually liked it better.

Regards,

Mauritz

Mauritz_SA
Partner - Specialist
Partner - Specialist

And sorry, I didn't know that the request was specific to the location of the row/column, I just though you wanted to get a totals row/column Smiley Happy

OmarBenSalem

Not possible.