Problem with headers of totals in pivot tables

[#1]

Hi all!!

I have a problem with headers of totals in pivot tables, I need that the totals column description has the content as the previous dimension (total + dimension name,red letters in the image), something like this:

I've tried playing with the value of the previous dimensions and te column() function... but does not work in pivot tables. Can anyone help me?.

Thanks for all!!

[michael_maeuser]

see attached

[michael_maeuser]

in your case instead of CustomerID, write ='Total ' & dimensionname

[#4]

Thanks for your reply, but don't works, not recognize the dimension name and paint '-':

[#5]

Any more idea??

[michael_maeuser]

i thought it worked with just the field name, but that only helps (of course, after rethinking ) if you have selected a dimension value. i guess there is no solution, i rememeber i had the issue a year ago and neither found a solution for this

[#7]

I think the same, thanks for your help Michael.

Regards.