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.

vinay_lohakare5 · ‎2012 May 10

Hello Simon,

You should have the region field in the data provider.

You can restrict the key figures with the specific region to get the data.

Example:

Each region will the product sold associated with it.

If Product A and B are sold in Jan and X and Y are sold in Feb in South region, the region south will have A,B,X and Y product assiciated with it.

So in the month of Jan it will have A and B and In Feb it will have X and Y, and if we see data for Jan and Feb it will show data for A,B,X and y.

Thanks,

Vinay