I have created a small pivot table in Excel 2007,

In the row labels, I have 3 stores.

I would like to display information below each store as follows:

Store1
Average Profit of Store1
# of Sales
Total Sales by Store1
Store2
Average Profit of Store2
# of Sales
Total Sales by Store2
...
...
...
I thought this would be accomplished by changing the field settings and choosing custom subtotals, But they are not showing up!!! I have now spent 5 hours researching the net, and reading the Excel help over and over.
Does anyone have any suggestions? Am I missing something?

Best regards