Name totals in Pivottable

[francisvandergr]

I wanna change the name of the totals in a pivot table. Every total must have another name.

I work with partial sum.

I attached an example.

[r_wroblewski]

Hi Francis,

you can use

Chart Properties -> Presentation "Label for Totals" to change Name of different SubTotals.

1) Select the dimension which total you want to rename

2) Fill in new label or expression

Regards,

Ronny

[#3]

Hi,

I would also recommend that using a variable to store the label, making it easy to change the label of multiple objects. It would also make it possible to incorporate multi language support.

Good luck!  

[jonathandienst]

I am afraid that what you require is not possible without a complex workaround. It seems that the Total labels are not calculated per row but only once for the table

I saw a post here which described one such workaround, but I did not bookmark it. I suggest that you search the forum for a solution to your problem.

[r_wroblewski]

I'm not sure if this is the post Jonathan mentioned but I think this could help you.

Re: Showing Dynamic "Total Label"

Regards,

Ronny