Text Concatenation

[#1]

Hi,

I have create a pivot table and I have checked the partial sums box in presentation tab.

I don't want to see the word total so I had changed the label for totals to ='Total' &[Inventory Item Code]

However, the pivot table only returns the word Total as shown below

[swuehl]

I believe the text that should be shown in a total line can only be set in total context, i.e. you can't change it per dimensional value.

[#3 · Accepted solution]

Hi Stefan

Thanks for getting back to me so you can set it to any text you like but can't put the dimension in?

[swuehl]

You can put anything in you can also print in a text box chart object, I believe. Hence no value specific to the line.

[#5]

Ok thanks. I thought you'd be able to pull values through