How do I do summary calcuations in 1 query instead of 2?

[LLPoolJ]

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? ???

[Gollapudi]

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.