Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a bar chart where on the X axis I have YYYY-MM and on Y axis it shows Profit+Loss.
The chart is very dynamic, it changes based on the currency picked, country etc.
I was wondering if there is a formula/expression which would show me the largest bar.
So lets say I have the chart for the past 5 months, where on 1st month the sum is 100, 2nd month 50, 3rd month 500, 4th month 10 and 5th month 5. So what would be the expression that would return me the value 500?
In Expression:
=if(aggr(rank(sum(sales)),Month)<=1,sum(sales))
firstsortedvalue can do that.
In Expression:
=if(aggr(rank(sum(sales)),Month)<=1,sum(sales))
Thank you, it works perfectly