I have a requirement where in the pivot table I need to show the Actuals and Planned regional wise month on month…
For actual : =(sum({<[Travel Mode] = {'Flight'}>}([Net Fare]))+ sum({<[Travel Mode] = {'Flight'}>}REC_AMOUNT))/1000000. Here I have different modes of travel.so inorder to differentiate I have given the travel mode as Flight in the set analysis.
I have been provided with the actual values regional wise in the below format for the flight alone.
For Planned : I have used the following expression : =aggr(only(Trip_Targets),Month,Month_Trip,[Contract Region] )
I should get the values of the corresponding months in the above first table in the pivot table. But I don’t know where its going wrong.Please look into this and let me know if u have any solution for this….