No, I do not want them in the Grand Total which is why I attempted to filter them out using the Group Selection formula.
I have also tried to filter them out using the Record Selection and I get the same results.
It just doesn't make sense. . .
Ok, I went back and took out my summaries and used running totals for group 2 and 3. These are returning the correct results.
When I do a 3rd running total (which I want to [grand]total group 1), its still returning a total that includes the values for the statuses I excluded.
Perhaps I have...
I work for an international tradeshow mgmt company that sells booth space and sponsorships. I am creating our comprehensive status report that shows all sales, by event# (using a parameter), grouped in the following ways:
Group 1: Order Type (Exhibit Space, Sponsorship)
Group 2: Order Status...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.