PivotTable grouping value

[davidcoder]

Hi, I'm trying to group value for category column, I have a source data like below :

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Category[/TD]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Item[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Cat A[/TD]
[TD]2[/TD]
[TD]AA[/TD]
[TD]Item 1[/TD]
[TD]$2[/TD]
[/TR]
[TR]
[TD]Cat A[/TD]
[TD]2[/TD]
[TD]AA[/TD]
[TD]Item 2[/TD]
[TD]$3[/TD]
[/TR]
[TR]
[TD]Cat B[/TD]
[TD]3[/TD]
[TD]BB[/TD]
[TD]Item 3[/TD]
[TD]$4[/TD]
[/TR]
[TR]
[TD]Cat B[/TD]
[TD]3[/TD]
[TD]BB[/TD]
[TD]Item 4[/TD]
[TD]$5[/TD]
[/TR]
</tbody>[/TABLE]

Below is how I want to present my data in pivottable:


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]+ Cat A[/TD]
[TD]2[/TD]
[TD]AA[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

Item 1​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]$2[/TD]
[/TR]
[TR]
[TD]

Item 2​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]$3[/TD]
[/TR]
[TR]
[TD]+ Cat B[/TD]
[TD]3[/TD]
[TD]BB[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

Item 3​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]$4[/TD]
[/TR]
[TR]
[TD]

Item 4​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]$5[/TD]
[/TR]
</tbody>[/TABLE]


Can this be done in pivottable ? Thanks for your help.

 

[Capt.Ragnar]

I don't want to say definatively that it cannot, but just by looking at it, within a single table, no.

The closest you could get within one table without formatting multiple tables to look like one, I think, is:
[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]Row Label [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: center"]Sum of Price[/TD]
[/TR]
[TR]
[TD]+Cat A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Item 1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]AA[/TD]
[TD="align: center"]$2[/TD]
[/TR]
[TR]
[TD="align: right"]Item 2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]AA[/TD]
[TD="align: center"]$3[/TD]
[/TR]
[TR]
[TD]+Cat B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Item 3[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]BB[/TD]
[TD="align: center"]$4[/TD]
[/TR]
[TR]
[TD="align: right"]Item 4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]BB[/TD]
[TD="align: center"]$5[/TD]
[/TR]
</TBODY>[/TABLE]