Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to set a dynamic value for a max axes. The automatic max value don't show the value as shown in image
The yellow expression is:
(((sum([FIELD A]+[FIELD B])) / Count(DISTINCT [FIELD C])) /
Above(((sum([FIELD A]+[FIELD A])) / Count(DISTINCT [FIELD C])))) -1
How I can calculate the max of this expression?
Try something like this:
Max(Aggr(
(((sum([FIELD A]+[FIELD B])) / Count(DISTINCT [FIELD C])) /
Above(((sum([FIELD A]+[FIELD A])) / Count(DISTINCT [FIELD C])))) -1, yourDimension))
Best,
Sunny