Hello,
I hope somebody can help me so get the max and min of cumulative columns. I am struggling a couple of days with internet but still no victory. Maybe somebody has the same issue in the past 🙂
I have a chart with two measures. One for werkkapitaal and the other for % werkkapitaal on revenue. So I have two Y axes.
The data for my chart is generated by this formula:
(rangesum(above(total rangesum(above(TOTAL Sum({$<[Grootboekrekeningnummer]={">=1300<=1390"}>}[Bedrag Saldo]),0,RowNo(TOTAL))),0,12))
+
rangesum(above(total rangesum(above(TOTAL Sum({$<[Grootboekrekeningnummer]={">=3000<=3998"}>}[Bedrag Saldo]),0,RowNo(TOTAL))),0,12))
--
rangesum(above(total rangesum(above(TOTAL Sum({$<[Grootboekrekeningnummer]={">=1600<=1601"}>}[Bedrag Saldo]),0,RowNo(TOTAL))),0,12)))
/
12
It's a cumulative calculated column and summed with the 12 periods before. And this is then also cumulative. So far so good.
Now I want to make the axes automatic scaling. In the attachment you can find the data. I want to fetch the max and the min from werkkapitaal and % werkkapitaal. On the community I read that max with rangesum is difficult and I can not do this. In my dashboard the customer can filter on companies. So the chart is everytime different.
Does somebody tackled the same challenge? I think if have provied enough info but shout when you need more.
Kind regards,
Martijn Wanders
