I have always been using 2 queries to do some group calculations on items. I use the one query subordinate to another query and have the host query summary the details of the sub query. I think I should be able to do it all in one query. Just not sure how? ???
Hi,
Let me tell you what I have understood from your query..
You got 2 queries, one is having Data in summary level and in other query you have detail level of data...
And now your looking for a single query which contains both summary and detail level...
and my solution for this is
you could create calculated items using Total([Data Item] for <Level>), this will help you to get the summary to a perticuller level like the below example...
Suppose in my query I have few Geography columns and then Retailer information, now I need summary value for retailersite level.... I could write Total([Revenue] for [Retailer Site])
Hope this might helps you, if this not your looking for, please gimme a detailed description about your issue with some example.
Thanks,
Gollapudi.