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

Question
1

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:
Stack
First row is Cat01 (by example) and second row is Cat02
Thanks in advance,

Miguel

2

…I had got a solution:
transpose
rename column
transpose

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

Regards,
Miguel
PS: Happy EasyDataTransform in 2023 to all!

3

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.

image
image1424×148 36.9 KB

rename-row.transform (2.7 KB)

4

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

1 Like