Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table and would like to show totals at the end of each row.
When I add 'show partial sum' this add it to the columns and not rows!
Can this be changed anywhere?
I've looked in all the properties and can't find anything that jumps out as row totals.
Andy
Hi
If you have pivoted any dimensions to column headings, you can total the rows using partial sums. If you have no dimensions in the column headings (ie only expressions), then the partial sum does not work. Instead, you can total the rows by creating a total expression that adds the columns:
=Column(1) + Column(2) + Column(3) .....
Hope that helps
Jonathan
Hi
If you have pivoted any dimensions to column headings, you can total the rows using partial sums. If you have no dimensions in the column headings (ie only expressions), then the partial sum does not work. Instead, you can total the rows by creating a total expression that adds the columns:
=Column(1) + Column(2) + Column(3) .....
Hope that helps
Jonathan
Thanks Jonathan
Much appreciated.
Andy
Thank you. So simple.