Show values greater than 100 as 100+ in pivot table and retain the sum of the column

[prat1507]

Hi

As clear from the subject, I need to Show values greater than 100 as 100+ in pivot table and retain the sum of the column.

Thanks in advance

Regards

Pratyush

[MK_QSL]

Can you clarify ?

I need to Show values greater than 100 as 100+ in pivot table and retain the sum of the column

[sunny_talwar · Accepted solution]

May be this

If(Dimensionality() = 0, Sum(Measure), If(Sum(Measure) > 100, '100+', Sum(Measure)))