problem with total label in pivot table

[qv_testing]

Hi Community,

I have a pivot table, which shows partial sums for the third dimension i.e Month-Year.

Total label showing twice.

Thanks in Advance...

[Sergey_Shuklin]

Hello, Raju!

Name the first total as "total" and the second total as ' '.

[qv_testing]

Sorry, i didn't get you.

[neha_shirsath]

This is coming 2 times because it consider Month year and sub product row wise so for both it shows differently Total field.

[qv_testing]

Yes, i understand that.

but, how to get rid of that.

[neha_shirsath]

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.

[qv_testing]

if users select any value, it will reduce chart, it will appear again.

That is not correct way.

[#8]

Hi,

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

[qv_testing]

I know that, problem is, if i drag up my dimension, users always scroll to see totals.

they need to see each level sub totals.

[qv_testing]

Experts, anyone can help me.