I have fields, amount, city, states. Created crosstab report something like below. I want to show subtotals for each state.I can do this in regular report, but for some reasons we have to create as cross tab.
Any help please....Thanks...

desription amount city state
gas 100.00 city1 state1
water 200.00 city1 state1
coke 300.00 city1 state1
SUBTOTAL 600.00

gas 400.00 city2 state1
water 200.00 city2 state1
coke 200.00 city2 state1
SUBTOTAL 800.00

SO ON....