How to set 100% as limit within crosstabs?

Hello everyone,

how does it work to display 100% for all values (which are calculated as percentages within a crosstab)that are greater than 100%?
Is there any option provided? So far, I could not find any information on this topic.

I highly appreciate any help or further advise!

Best regards

Find more posts tagged with

Comments

mwilliams

There are several things you could do. You could delete the measure element and replace it with a dynamic textbox or data element and write an expression to output 100% if the measure value is greater than 100%. Another possibility could be to use mapping to replace any value over 100% with 100%.

Hope this helps.