Sub Total Titles in a pivot table

[#1]

I cannot put an expression in the property where you can put the title for a subtotal in a pivot table.

If I just paste a field as 'Customer' ... the result is a ' - '

But if I put something as a text ...that works ...

Any helps?

Thanks in advance

[#2]

I mean the label of the Subtotal

[#3]

The issue might be that the Subtotal label is not looking at your dimensions.

I bet that if you use the field Customer as the label, and then select a single Customer it works?

[#4]

That's true Marcsiliving ... the point is that I need to show one or more dimension .... in the same pivot at time.

[#5 · Accepted solution]

I ran into the same issue when I wanted the label to change based on the dimension.

I was never able to find a solution and ran into to many other issues so I just created what I needed in Crystal Reports. (In my case they needed only the Excel export, not to actually see the data and how it changes)

Edit: I just did a search and found this:  http://community.qlik.com/ideas/1156#comment-2442

Seems like it is not currently available.