1 of 1 people found this helpful
This appears to be a great case for using a dashboard. Are the totals correct for June and July if the field IOT is removed from the Columns shelf? If so, I woul ddisable the totals from the analysis menu (no matter what you won't get split grand totals by month across the row) and then create a Totals only view from a copy of the first view. See the sample dashboard below. Note the filter is set to be applied to both worksheets. .
i hope that helps
I'd been meaning to respond to this one - using two measures (one for June and one for July) in a Measure Names/Measure Values crosstab would also work.
Sorry for extremely delayed response , it worked like charm, i build tonnes of pages using this trick