Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to show Plan,Actual and Forecast values on monthly basis and their difference as a different fields.I got correct result for Plan and Actual as a totals but i am facing the issue with forecast values.
Forecast value is getting total sum for months but i need as separate monthly values.
Please find the attached image for reference.
Expected Output: for the Forecast Field i want output like(Forecast is calculated value coming from above 1+11 forecast,2+10 Forecast .....11+1 forecast)
-> 74 for Feb(which is correct from 1+11 Forecast)
-> 74 for Mar(need to take value from 2+10 Forecast instead it is taking total of (1+11 forecast and 2+10 forecast))
-> 74 for Apr(need to take value from 3+9 Forecast instead it is taking total of (1+11 forecast and 2+10 forecast and 3+9 forecast))) .....so on till Dec
Dimension and Expression is used:
Dimension:
Pick(Dim, Period,'Plan','Actual','Forecast','Actual-Plan','Forecast-Plan')
Expression:
=Pick(Dim, Sum(Value),
Sum({<Period= {'Plan'}>}Value),
Sum({<Period= {'Actual'}>}Value),
Sum({<Forecast= {'Forecast'}>}Value),
Sum({<Period= {'Actual'}>}Value)-Sum({<Period= {'Plan'}>}Value),
Sum({<Forecast= {'Forecast'}>}Value)-Sum({<Period= {'Plan'}>}Value)
Thanks
Hi, Is the period part of the final table? and you want the bottom value for each month? Maybe with:
Top(Sum(Value), RangeMax(ColumnNo()-1, 1))
Hi, Is the period part of the final table? and you want the bottom value for each month? Maybe with:
Top(Sum(Value), RangeMax(ColumnNo()-1, 1))