Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
wgonzalez
Partner - Creator
Partner - Creator

Is it possible to add a total line independent of dimensions in pivot table?

Is it possible to add a total line independent of dimensions in pivot table?  For example, I want to add sum(Value1)  to a Total of a column in the pivot table.  In the example below, Total is the total line calculated by the pivot table.  The "Total vs Variance" is a calculated value of adding a value (not shown) to the negative total (in red).

2018-11-14_14-28-54.png

1 Reply
Gysbert_Wassenaar

No, that's not possible. You'll have to show that total in another object.

talk is cheap, supply exceeds demand