Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get horizontal totals in Pivot table

Hi All ,

Is anybody can advice me about how i can get horizontal total (which will placed at the end of pivot table ) for my rows.

Any examples / Links ??

Bhushan N

1 Reply
Not applicable
Author

Do you have any horizontal dimensions? If so, checking Show Partial Sums for those dimensions should put the totals on the right. To show Partial Sum, go to the Presentation tab of your chart and highlight the desired dimension. Then check Show Partial Sums.

If you don't have any horizontal dimensions, then the Partial Sums will always go below. In that case, I think you would need to manually create a Totals column. In this situation all of your expressions could be different, which is probably why there's no automatic method.

I've attached a simple example with two charts. One with the horizontal dimensions, the other without. I also changed it to Subtotals at top, which will put the subtotals at the top and left rather than bottom and right.