How can I get a Grand total variable or expression, with the subtotal results from 2 different pages. The Total () function does not really work for me. I am guessing the first step would be to put both pages in a page set.
Are the values coming from two separate queries? Is this dimensional or relational?
Yes, two different queries due to conflicting filters. Relational.
Make a singleton, put the subtotal in the properties of the singleton. Nest another singleton into the first one. Put the subtotal into the properties. Using a layout expression do [Query1].[Subtotal] + [Query2].[Subtotal].