Get a grand total that disregards filters

[thedon_1]

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?

[blom0344]

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