Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have attached the one treemap view chart below.
In That i have created Actual and budget measures using below expression. vMapseletion variable when user select in filter in actual it show the actual value and user select budget it show the budget value.i can able to get the values correctly.
=pick(Match($(vMapselection),'Actuals','Budget'),
Num(Sum({<[Budget Type Code]={'Actuals','Actual'}>}Expense))
Num(Sum({<[Budget Type Code]={'Budget'}>}Expense))
My Requirement is need to change the measure name based on selection.
ex if user select budget it show the budget value it is fine.same time need to show that value name is budget.if select actual it show actual name.
Hi ,
Go to measures - Under Label type following formula
=pick(Match($(vMapselection),'Actuals','Budget'), ' Actual','Budget')
Hope this helps you
Vikas