Pivot Table Subtotals

[Nine Zero]

Hello All!

I am trying to organize a pivot table to she me subtotals at the bottom of each "group" and also have a count at the top of each "group"

Example: This is what i would like to achieve

Route 1 Count	2	1	1	2	2	2
Store 1	5			30		15
Store 3			40		1
Store 5	2	15			52
Store 7				45		8
Route 1 Total	7	15	40	75	53	23
Route 2 Count	3	2	2	2	2	1
Store 2	51		2		3
Store 4		14		2		2
Store 6	11		2	21
Store 8	11	5			47
Route 2 Total	73	19	4	23	50	2

<tbody>
</tbody>

Let me know if anyone has any suggestions

 

[Nine Zero]

Bump