Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to show table where it will one (the highest value)and its date within each month.
The problem is that I calculate aggr function on month year level, but when I would like to show maximum date within month which is lower level than month year it will fail.
The other task is not to show other dates where maximum value isn't.
In the printscreen below you can see within pivot table I am able to do it this way but I am unable to hide those non maximum dates..
if(aggr(rank(Calculation),Month_Year,Date)<=1,Calculation)
Can you send a sample app, but I am sure you can do it by hiding nulls and zero values.
You have values in the other two expressions, Exposure low and settlement, do you want to hide those values as well?
please post a sample app
Share the sample app with the required output so that it will help us to understand
I already fixed it: by combination of function rank and aggr
if(aggr(rank(calculation),Month_Year,Datum)
if(aggr(rank(Calculation),Month_Year,Date)<=1,Calculation)