Pivot table subtotal?

[Myriad_Rocker]

I'm wanting to include a subtotal of all category data in a pivot. I was wondering if there was a setting I was missing.

Example:
State Type Sales
AZ 1 900
AZ 2 100
AZ 3 200
AZ Total 1200
CA 2 1000

etc

So, I have it totaling by state. But I want a total at the very bottom just by type, regardless of state. Can I do that?

 

[Myriad_Rocker]

The formatting there didn't work out how I had intended but I can't copy the actual data or attach it...it's sensitive sales data.

 

[Andrew Poulsom]

Either change the order of your row fields or move one of the items into the column field.

 

[Myriad_Rocker]

Either change the order of your row fields or move one of the items into the column field.

Well, I meant in addition to my state totals. I want those in there. I just want type totals regardless of state, as well.

 

[Andrew Poulsom]

Sorry, only the first item in the row field is subtotalled.