I have a report that ranks Profit by Supplier for 2 time periods.
Period one will have a top 10. Period two has a top 10.
I use the filter Rank <11.
I need a grand total figure for profit, one that disregards rank in order to work out % values.
When I do total([Profit] for [Period]) I only get the sum of the top 10, not the absolute total profit for that period.
Any ideas what i'm doing wrong?
Why spread all your questions over multiple posts regarding one subject?
To answer your question:
A single query will bring back a set of data based on filters applied. You cannot 'reuse' it and expect it to bypass the filter for a new calculation. The type of value you are after is something that is most elegantly handled by singletons (= new query) as they can be used everywhere in the report. If you need a dataset returned I would define another query altogether or use a union against the sets.
I believe this was discussed in another post on the subject