Skip to Content
0
Former Member
Oct 18, 2011 at 04:28 AM

Crosstab - Add a row to the subtotal

101 Views

I have a subtotal in my crosstab where there are 3 rows of totals from previous rows. I would like to create a row that takes the subtotals and divides the 1st row by the 2nd row.

Subtotal1

Subtotal2

Subtotal3

Subtotal1/Subtotal2

How does one insert a row into the existing subtotal?

I can't seem to get the Calculated Member to work. Can someone give me a hand?

Thanks in advance.