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.