Pivot table formatting to split sections based on category

[Dayna]

Hello all!

A random one, and not quite sure how to approach it... I have a pivot table with a list of items and I want to split sections off based on category. The table currently looks like this:

	Category	Sales	Sales	Sales
Part	Timescale	2015.30	2015.31	2015.32
Product A		672	-	672
Product B		540	6,480	5,940
Product C		540	6,480	5,940
Product A		-	-	6,048
Product B		5,040	5,760	4,800

And I want to put categories in to look like this:

	Category	Sales	Sales	Sales
Part	Timescale	2015.30	2015.31	2015.32
CATEGORY 1
Product A		672	-	672
Product B		540	6,480	5,940
TOTAL
CATEGORY 2
Product C		540	6,480	5,940
Product A		-	-	6,048
TOTAL

I know I can add it as another dimension, but I didn't want another dimension, just a split/divider between the sections.

Please help! Any assistance is always appreciated

Kind Regards,

Dayna