Skip to Content
0
Former Member
Oct 26, 2012 at 01:42 PM

Bex constant selection query

90 Views

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 50

when 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.