Query design

[#1]

Hi

I need to create a query with characteristics Product ID,0CALDAY,Sales Region,Sales Amount where the report result should be like below:

User want to input Product ID and 0CALDAY and result should display how much this product was sold in various Sales Regions as shown below:

Sales Region----Sales Amount

A--------------------100

B--------------------200

South(=A+B)-----300(South is Sales Zone which has Sales Regions A,B.So South is sum of A&B=100+200=300)

C--------------------150

D--------------------200

North(=C+D)-----350(North is Sales zone which has sales regions C&D.So North is sum of C&D=150+200=350)

Total--------------650(Sales of South and North together)

How can I create this query?

Thanks.

[Former Member]

Hi Simon,

This can be achieved by hierarchy on Sales Region. Multiple level of hierarchies will resolve your requirement.

Include Zones(South & North) in first level and Region (A & B) in second level. On drilling down to required level, Sales amount will be displayed.

Please post this question in BEx place (http://scn.sap.com/community/business-explorer) for clear quick and exact replies

Regards

Chandu