How to calculate the largest class value

[dafnis14]

Hi,

I would like to display dynamically the largest class value of a calculated dimension based on Class and a slider,

in the Other label defined in the Dimension Limit tab.

Is there a way to do it?

Thanks!

[Oleg_Troyansky]

If I understand your question correctly - yes, you should be able to do it if you copy/paste the same calculated dimension formula (which must be using the AGGR() function) and enclose it in a MAX() or a MaxString() function.

The only caveat is the alphabetic sorting of the result of the Class - the string 100 will be preceding the string 90. You may have to extract the numeric value of the lower (or higher) end of the range and force it into a numeric format in order to get a reliable maximum...

[dafnis14]

Hi Oleg,

Thank you for your prompt reply.

Since I needed the first 5 values, I had to apply the Min function.

Also, i added the above expression as the first table expression (hidden), in order to apply the desired dimension limit.

thanks!