Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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