in a report we have a free characteristic Project ID and Account and have to calculate the varaince associated with Planned Vs actual.
Actual report will look like.(case 1)
Region Sector Plannned Actual Variance India A 600 500 -100 India B 600 550 -50 India C 600 600 0 India D 600 550 -50 India E 600 700 100 India F 600 600 0 India G 600 650 50when we drill down the above report with project id it will look like this.
Desired result :- region ,only one sector ,project id , actual is displayed. No values in planned and variance.(case 2)
Region Sector Project ID Plannned Actual Variance India A 101 ## 500 - India A 102 ## 550 - India A 103 ## 600 - India A 104 ## 550 - India A 105 ## 700 - India A 106 ## 600 - India A 107 ## 650 -when we drill down it through Account it will look like this.
Desired result :- Region ,only one sector ,Account , planned is displayed. No values in actual and variance.(case 3)
Region Sector Account Plannned Actual Variance India A 201 600 ## - India A 202 600 ## - India A 203 600 ## - India A 204 600 ## - India A 205 600 ## - India A 206 600 ## - India A 207 600 ## -please let me know how to get the above results i.e in case 2 , and case 3 on the basis of drill down in BEX Query.