Static (dynamic) max on y axes

[nboccassini]

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?

[sunny_talwar]

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