Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
infosense_devel
Creator II
Creator II

In Pivot Table display two times "Total"

Hello,

I have prepared one pivot table which contains Four dimensions, and MTD and PYTD expressions and I have do pivoting with one dimension called "Month".

In Presentation tab I have marked "Show Partial Sums" for all dimensions,

After than when I look into Pivot Table, it displays Two times Total in Partial sum of Month as like as below.

Need only One time Total as per below.

Thanks,

In Advance.

1 Reply
olivierrobin
Specialist III
Specialist III

hello

for me, it means that you have 2 different values for salesrep, so 1 total line per each