Showing Dynamic "Total Label"

[prasad_dumbre]

Dear Experts,

As shown in below image, in pivote table, whenever we apply partial sum , label Total gets displayed

My Req. is it should show, that particular dimension value & ' Total' .

like below image:

Is it possible ???

Thanks in advance . . .

Regards,

Prasad D. Dumbre

[prasad_dumbre]

Hi Anbu,

Thanks for your feedback.

Can you guide how can we do similar with more dimensions, as i tried your approach but i got output like this

I want last line label "India Total: 12".

Is it possible ?

[anbu1984]

Yes. Try this

If(Dimensionality() =2, Currency & ' Total : ' & Sum(Sales),If(Dimensionality() =0, Market & ' Total : ' & Sum(Sales),Sum(Sales)))