
Creator II
2018-04-16
08:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
575 Views
1 Reply


Specialist III
2018-04-16
10:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hello
for me, it means that you have 2 different values for salesrep, so 1 total line per each
541 Views
