cancel
Showing results for 
Search instead for 
Did you mean: 

How to make a report based on the result of another report?

Former Member
0 Kudos

Hi, All,

I am a new guy in BW development

I made the report1, to show the "Total Sales in each country and each shop "

(the fact table is "Order")

now I want to make report2 "in each countries, the number of the shops, whose Total Sales >100000"

Can I make the report2 based on the result of report1 (use the same fact table)

thanks a lot

QY

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks for the reply.

but i need not only a condition, but the aggregation of numbers of the shops , whose total sales > 100000 in each countries (e.g. USA, germany)

klaus_werner
Active Participant
0 Kudos

For this you could use local aggregation in the result query (context menu-> calculate-> result as->summation. Then you'd see the details and the sum of the details (I think).

Regards, Klaus

klaus_werner
Active Participant
0 Kudos

Hi,

you don't even need two reports. What you describe can be implemented with a "condition". If you activate the condition you can see only >100000, otherwise you can see everything. Please look for documentation of conditions in the online documentation or press the condition button in the query designer and just try.

REgards, Klaus

Former Member
0 Kudos

Hi Klaus,

your condition only works if the Shop is in the query. If I understood it correctly you have one query with

Country Shop Total Sales

and one with

Country Number of Shops Total Sales

and you don't want to restrict the second Total Sales but the Total Sales from the first query.

Best regards

Dirk

Former Member
0 Kudos

You should create a condition on report1 with Total Sales > 100000. Now you can create a replacement variable (e.g. for shops) where you can choose 'Replace from Query Result' and enter report1. This variable should be used in report2 to restrict the shops.

If the performance is bad, try to use result sets in the Reporting Agent.

Best regards

Dirk