Query design

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_member188080 · ‎2012 May 07

Hi,

You can have hierarchy mentioned as above

2. You can maintain master data difefreently and use formulae in the query

3. You can define calculated KF to calcualte the summation,use 3 RKF and then sum them

4. you can use workbook for these cxalculation if they are fixed nature..you can put macros if needed..

Thanks and regards

Kiran