Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
If(Dimensionality() = 0, Sum(Measure), If(Sum(Measure) > 100, '100+', Sum(Measure)))
Can you clarify ?
I need to Show values greater than 100 as 100+ in pivot table and retain the sum of the column
May be this
If(Dimensionality() = 0, Sum(Measure), If(Sum(Measure) > 100, '100+', Sum(Measure)))