This seems like it should be easy, but I haven't been able to figure out how to do it.
I have a crosstab report with quarters in the columns and the following in the rows:
Product Category
Product
Product Detail
(Revenue, Cogs, Margin)
When it runs it gives me something like this:
Product Category1, Product1, Product Detail1, Revenue
Product Category1, Product1, Product Detail1, Cogs
Product Category1, Product1, Product Detail1, Margin
Product Category1, Product1, Product Detail2, Revenue
Product Category1, Product1, Product Detail2, Cogs
Product Category1, Product1, Product Detail2, Margin
Product Category1, Product1, Product Detail3, Revenue
Product Category1, Product1, Product Detail3, Cogs
Product Category1, Product1, Product Detail3, Margin
Product Category1, Product2, Product Detail1, Revenue
Product Category1, Product2, Product Detail1, Cogs
Product Category1, Product2, Product Detail1, Margin
etc...
My questions is how do I get a subtotal in for Product 1? Basically this:
Product Category1, Product1, Product Detail1, Revenue
Product Category1, Product1, Product Detail1, Cogs
Product Category1, Product1, Product Detail1, Margin
Product Category1, Product1, Product Detail2, Revenue
Product Category1, Product1, Product Detail2, Cogs
Product Category1, Product1, Product Detail2, Margin
Product Category1, Product1, Product Detail3, Revenue
Product Category1, Product1, Product Detail3, Cogs
Product Category1, Product1, Product Detail3, Margin
Product Category1, Product1, Subtotal, Revenue
Product Category1, Product1, Subtotal, Cogs
Product Category1, Product1, Subtotal, Margin
Product Category1, Product2, Product Detail1, Revenue
Product Category1, Product2, Product Detail1, Cogs
Product Category1, Product2, Product Detail1, Margin
Click on Product1, then click summarize (sigma button). It will add a subtotal row for Product1.