The Label for Partial sums in the Pivot Table

[jixiaoquan]

Hi everyone,

     I have question about the label for partial sums in the pivot table.

     There are three dimensions in the pivot table,GMNME,DIRECTORNAME and  MARKETNAME, just one expressions.

     I want to use the partial sums in the pivot table.

     The total Label like 'GMNAME-Total'.The GMNAME is the content of GMNAME.like 'Ada-Total',in the Label for I write '=GMNAME&'Total'',but it does not work.

     Could you tell me how to do?

    

[jonathandienst]

Unfortunately the partial total labels cannot respond to the value of the dimensions and in your case, the value of GMNAME in the total label will always be null. I do not recall seeing a workaround.

[tresesco]

Kind of workaround could be like explained here: Custom Labels in Pivot Table or using Properties ->Style ->Indent Mode

[petter · Accepted solution]

If you are willing to accept an extra column in the form of an expression this might work for you:

You must put a space character in all the Sub Total Lables.