Custom message for shrinked Pivot

[Anonymous]

Hi Community

Does anybody know in case of no data in pivot; (pivot shrinked)

I want to add message 'No data for this selection'

Thanks

[sunny_talwar · Accepted solution]

You might be able to use the calculation condition and error message to do this: Use Count(dimension) to check for calculation and use 'No data for this selection' as the error message.

HTH

Best,

Sunny

[Anonymous]

Thanks Sunny for your suggestion

[sunny_talwar]

Not a problem. I am glad this was helpful.

Best,

Sunny