cancel
Showing results for 
Search instead for 
Did you mean: 

Query Designer

martin_bako
Participant
0 Kudos

Hi,

I have to build a query in QD 7.0 which schould cotain the Countries (Hierarchy) in the Rowes and Revenue % in the Columns.

I have to show the revenue% in three catagory: >30%, 10-30% and <10% with sum for each catagory, somehow like this:

Greater than 30%

usa 40%

can 31%

.

.

sum

Between 10-30%

IT 20%

CA 21%

.

.

sum

Less than 10%

DE 9%

FR 8%

.

.

sum

Total sum

can any one tell me how to do it. I tried with conditions but it does'nt work.

Thanks for any help in advance

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Martin,

Customer Exit variable will help you to do this requirement for the report . For help, refer one of the Aging query of FI-AR/AP which is similar to your issue.

Refer Standardquery:

Query name: 0FIAR_C03_Q0001

Cube: 0FIAR_C03

http://help.sap.com/saphelp_nw04/helpdata/en/70/10e73a86e99c77e10000000a114084/frameset.htm

Regs,

VACHAN