rename the label for partial sums

[ali_hijazi]

Hello

I need to rename the partial sum label to "Total " plus the value of the related dimension value

I tried the following:

='Total ' & $(CategoryName) // where CategoryName is a Dimension in my pivot table

however I get the following as display for the lable :

Total -

[#2]

have you tried without the $() ?:

='Total ' & CategoryName

[ali_hijazi]

Yes same result

[kaushiknsolanki]

Hi,

    Have a look at the attachment.

    Hope this will help you.

Regards,

Kaushik Solanki

[ali_hijazi]

your attachment is helpful but I can't display the string Total 101 , Total 102,... where 101 and 102 are values under the ID

The parital sum are to be on the AMT column

[kaushiknsolanki]

Hi,

   Sorry i dont think so you can do that. You cant have Field Values with total.

Regards,

Kaushik Solanki

[ali_hijazi]

can we check if the value of the diemension is X then I write X as a string?

[kaushiknsolanki]

Hi,

   Actually the problem is you want partial sum. so you will get sum on say second dimension. so in that you cant access value of first dimension.

Regards,

Kaushik Solanki