Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table row totals

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

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks Jonathan

Much appreciated.

Andy

Sheron-Al1
Contributor
Contributor

Thank you.  So simple.