Hello All,
I wish to achieve below:-
Created inline table for filters
load *inline[
Dimension
Actual
Budget
Bugdet 2020
];
I have to create a filter of the above table and create a data table .
If user select "Actual" it should display the expression of actual (Sum(Sales))
if user select "Buget", then display the expressiom Sum(Amount)
if user select Budget2020, then it should display expression sum (Currency)
I tried below
-Created the inline table
-took the dimension
in the expression of the chart , i tried
if(getfieldselection(Dimension)='Actual', Sum(Sales),
if (getfeildselection(Dimension)='Buget, sum(Amount)
else Sum(Currency).
Still not getting the correct result.
Can anyone please help ?
