Hi to all,
- We have 2 queries
- Query#1 has data items and metrics to display the GREAT TOTAL with no user prompt selection
- Query#2 has data items and metrics to display totals based on what the user selected on the prompt page
QUERY#1
– Great Total –
[Total Sales] (NO user prompt selection)
[Total QTY] (NO user selection)
[Total QTY] / [Total Sales]
QUER#2
– Total Based on user prompt’s selection –
[Total Sales] (based on user selection)
[Total QTY] (based on user selection)
[Total QTY] / [Total Sales]
Should i create a Query#3 based on a JOIN between Query#1 and Query#2 to calculate the following:
[Total Sales] (based on user selection) / [Total Sales] (NO user prompt selection)
[Total QTY] (based on user selection) / [Total QTY] (NO user selection)
The thing is that i don’t have all the same data items (ID’s) on both queries (simply not all displayed on report) as for i don’t really need them on both queries.
How should i deal with this ?
Thank you for any valuable suggestions !