Subtotals for Crosstab Report

[bergmanmh]

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

[tjohnson3050]

Click on Product1, then click summarize (sigma button).  It will add a subtotal row for Product1.