Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hello
for me, it means that you have 2 different values for salesrep, so 1 total line per each