I have to build a crosstab report with site names as the rows, month-year as the columns, and dollar amount as the measure.
The customer wants three totals: a YTD total for each site, a monthly total for each month, and a cumulative total that increases with each subsequent month.
Everything I have tried either just does another standard total or changes all the values.
How do I add a running total row to the bottom of my crosstab?