I have a pivot table, which shows partial sums for the third dimension i.e Month-Year.
Total label showing twice.
Thanks in Advance...
I think we will not removed 1 because removing of one total text, its removing both so better way you need to do some extra thing like you can take text object and keep on 1 Total to hide that.
The issue is due to subtotal enabled for Month-Year and the dimension is placed below the expression name.
Screen shot for this explanation is given below.
When Month-Year is shown horizontally and below expression name.
When Month-Year is given above the expression names.
In the bottom screen shot you see only 1 total.
In the above screen shot it shows 2 total, top Total is for expressions and bottom Total is for Month-Year.
Hope it helps