Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a data that looks like below (simplified).
I need sum of current month plan based on the maximum plan revision. I have used this expression.
{<Plan month = {"$(=Max(Plan month))"}, Plan Rev = {"$(=Max(Plan Rev))"} >} Sum(Plan).
It works fine when I choose a month or works if all the months have 2 plan revisions. I would like this Max(Plan Rev) should take the current month in to account and display the max revision of that month.
Thanks,
Braveen
Hello, this formula should work
{<month = {"$(=Max(month))"}, Rev = {"$(=Max({<month = {"$(=Max(month))"}>}Rev))"} >} Sum(Plan)
try with [Plan month] as dimension and this expression
FirstSortedValue( Plan, -[Plan Rev])
Hello, this formula should work
{<month = {"$(=Max(month))"}, Rev = {"$(=Max({<month = {"$(=Max(month))"}>}Rev))"} >} Sum(Plan)
I am sorry @maxgro I didn't understand your suggestion. Could you please elaborate a little?
where do you suggest I use the FirstSortedValue? Since, it returns dimensions as output (I looked at the examples off the link you shared), I am not sure how it helps.
This is working as expected. Thanks @Clement15