Axis size with Aggr() should not react to selections in list box

[Janneke]

Hi all,

I have a column table where the size of the axis depends on the max of two charts:

=If(Max(Aggr(NODISTINCT Sum({1<DimensionA={1},DimensionB={2}>}Value),Date))>=Max(Aggr(NODISTINCT Sum({1<DimensionA={2},DimensionB={2}>}Value),Date))

  ,Max(Aggr(NODISTINCT Sum({1<DimensionA={1},DimensionB={2}>}Value),Date))

  ,Max(Aggr(NODISTINCT Sum({1<DimensionA={2},DimensionB={2}>}Value),Date))

    )

I use 1 in set analysis so that the chart doesn't respond to selections in list boxes. However, this doesn't apply on this formula for the axis size. I think the reason is the Aggr() with Date.

Can anyone explain to me what I need to change in order to get this working?

Thanks in advance, greetings, Janneke.

[jonathandienst · Accepted solution]

To prevent the Aggr() from reacting to selections, you need a {1} in the enclosing Max() as well as inside:

     Max({1} Aggr(.....)

[Janneke]

Brilliant!!

Thanks for the quick respons.