Discussion Board for collaboration related to QlikView App Development.
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.
for me, it means that you have 2 different values for salesrep, so 1 total line per each