How to change label from Grand Sum or Grand Count in pivot

Hi, I am stacking two pivots, and I would like to know if there is a way to change the label on Grand Sum. I have this:
First row is Cat01 (by example) and second row is Cat02
Thanks in advance,


…I had got a solution:
rename column

But, If there is another way, it will be great to know!

PS: Happy EasyDataTransform in 2023 to all!

If there is only 1 of a row you can use If to create a new column and then use this to replace the old column.

If there are multiple rows with the same value you can do it using Total + If.

rename-row.transform (2.7 KB)

Thanks, I will try it…and Happy New Year 2023!

1 Like