Max value of full accumulated sum in bar chart

[e_ko]

Hi community, 

I have two bar charts which need to have an equalized scaling. 

The scale should be the maximum of the first bar chart. This bar chart has a simple sum()-formula, but with full accumulation. 

Have a look at the pictures, I need to get 838 as formula... I tried with rangesum() or rangemax() but didn't get any further.

Thanks a lot for your help!

GraphicsProperties of bar chart

[Kushal_Chawda]

@e_ko  try below. Where highlighted filed is dimension of your chart

=max( aggr(rangesum(above(total sum(Amount),0,rowno()), (Month,(NUMERIC,ASCENDING)))))

[e_ko]

Hi @Kushal_Chawda thank you for your reply! I didn't get it to work as it says aggr() needs 2 parameters (?)

I've attached the QVW, maybe you can have a look at it?

[Kushal_Chawda · Accepted solution]

@e_ko  there was typo. Below works

=max( aggr(rangesum(above(total sum(Amount),0,rowno())), (YYYYWW,(NUMERIC,ASCENDING))))

[e_ko]

Thank you! 🙂