Pivot table formatting to split sections based on category

Dayna — Mon, 21 Sep 2015 12:10:15 GMT

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

topic Pivot table formatting to split sections based on category in QlikView

Pivot table formatting to split sections based on category