Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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...
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!