Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
see attached
in your case instead of CustomerID, write ='Total ' & dimensionname
Thanks for your reply, but don't works, not recognize the dimension name and paint '-':
Any more idea??
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
I think the same, thanks for your help Michael.
Regards.