Formatting column names in Pivot Table report

[MechaNik]

Hi, 

I am using a Pivots in multiple pages of my app. The column names show "Sum of " as I am summing sales and similar numbers in multiple tables. Is there a way to format/edit this to remove "sum of". 

Ex. Pivot table column "Sum of Sales" to just "Sales"

[sandy159]

Hi @MechaNik,

You can remove the "Sum of" by modifying your Localization. First, go to your DataPage's Localization. Then, click Edit > Result Pages > Labels and Markers > Value columns.

You can see that its default value is "%f of %c". You can simply remove "%f of" and just leave the "%c" for the label.

I hope this helps! 

[autonumber]

Hi! I am just adding these links for more information on Localization:

https://www.youtube.com/watch?v=AM3-f4atgDI

https://www.youtube.com/watch?v=Fzf0efn_B5s

https://howto.caspio.com/localizations/localizations/