1 of 1 people found this helpful
Grand totals use whatever aggregation is on the field, it is not necessarily a sum of all the values. One way to show only the grand totals for Sales and Profit and not for Rolling Sales/Profit would be to place the latter two on a separate worksheet from the first two and place the worksheets on a dashboard together.
I had thought about a dashboard solution having seen something similar suggested in another post.
That just might have to be the way that the figures are presented.