Hi
I am facing an issue in frond end.there is a pivot table with below Dimension and Expressions
Dimension:
=Pick(Dim, Timeperiod,'Forecast', 'Actual - Planned', 'Forecast - Planned')
Expression:
=Pick(Dim, Sum(Value),
top(Sum(Value), RangeMax(ColumnNo()-1,1)),
Sum({<Timeperiod = {'Actual'}>}Value)-(Sum({<Timeperiod = {'Planned'}>}Value
(Top(Sum(Value), RangeMax(ColumnNo()-1, 1)))-(Sum({<Timeperiod = {'Planned'}>}Value)
I am getting correct result but problem is representation of Object. There is no fields as dimension like 'Forecast','Actual - Planned', 'Forecast - Planned' using pick function.
But i dont want single expression there any other option instead of pick function
i need below Individual Expression in chart as per requirement:
Forecast : top(Sum(Value), RangeMax(ColumnNo()-1,1)),
Actual-Planned: Sum({<Timeperiod = {'Actual'}>}Value)-(Sum({<Timeperiod = {'Planned'}>}Value
Forecast-Planned: (Top(Sum(Value), RangeMax(ColumnNo()-1, 1)))-(Sum({<Timeperiod = {'Planned'}>}Value)
