Hello guys
I have a table looking like this:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD="align: left"]Row[/TD]
[TD="align: left"]A[/TD]
[TD="align: left"]B[/TD]
[TD="align: left"]C[/TD]
[TD="align: left"]Sales[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]103[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]113[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]109[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]101[/TD]
[/TR]
</tbody>[/TABLE]
And from this table I create a pivot table. The result I need to get is this:
<tbody>
[TD="align: left"]A[/TD]
[TD="align: left"]B[/TD]
[TD="align: left"]Sum - Sales[/TD]
[TD="align: left"]0[/TD]
[TD="align: left"]0[/TD]
[TD="align: right"]150[/TD]
[TD="align: left"][/TD]
[TD="align: left"]1[/TD]
[TD="align: right"]102[/TD]
[TD="align: left"]1[/TD]
[TD="align: left"]0[/TD]
[TD="align: right"]345[/TD]
[TD="align: left"][/TD]
[TD="align: left"]1[/TD]
[TD="align: right"]268[/TD]
[TD="align: left"] Total Result [/TD]
[TD="align: left"][/TD]
[TD="align: right"] 865 [/TD]
</tbody>
What I exactly need as a final summary is not B being under A but A and B listed with all their values onto different rows.. Something like this
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD="align: left"]A[/TD]
[TD="align: right"]0[/TD]
[TD="align: left"]sum of sales[/TD]
[/TR]
[TR]
[TD="align: left"]A[/TD]
[TD="align: right"]1[/TD]
[TD="align: left"]sum of sales[/TD]
[/TR]
[TR]
[TD="align: left"]B[/TD]
[TD="align: right"]0[/TD]
[TD="align: left"]sum of sales[/TD]
[/TR]
[TR]
[TD="align: left"]B[/TD]
[TD="align: right"]1[/TD]
[TD="align: left"]sum of sales[/TD]
[/TR]
</tbody>[/TABLE]
Any idea how can i get the last table ?
Thanks in advance!
I have a table looking like this:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD="align: left"]Row[/TD]
[TD="align: left"]A[/TD]
[TD="align: left"]B[/TD]
[TD="align: left"]C[/TD]
[TD="align: left"]Sales[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]103[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]113[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]109[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]101[/TD]
[/TR]
</tbody>[/TABLE]
And from this table I create a pivot table. The result I need to get is this:
<tbody>
[TD="align: left"]A[/TD]
[TD="align: left"]B[/TD]
[TD="align: left"]Sum - Sales[/TD]
[TD="align: left"]0[/TD]
[TD="align: left"]0[/TD]
[TD="align: right"]150[/TD]
[TD="align: left"][/TD]
[TD="align: left"]1[/TD]
[TD="align: right"]102[/TD]
[TD="align: left"]1[/TD]
[TD="align: left"]0[/TD]
[TD="align: right"]345[/TD]
[TD="align: left"][/TD]
[TD="align: left"]1[/TD]
[TD="align: right"]268[/TD]
[TD="align: left"] Total Result [/TD]
[TD="align: left"][/TD]
[TD="align: right"] 865 [/TD]
</tbody>
What I exactly need as a final summary is not B being under A but A and B listed with all their values onto different rows.. Something like this
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD="align: left"]A[/TD]
[TD="align: right"]0[/TD]
[TD="align: left"]sum of sales[/TD]
[/TR]
[TR]
[TD="align: left"]A[/TD]
[TD="align: right"]1[/TD]
[TD="align: left"]sum of sales[/TD]
[/TR]
[TR]
[TD="align: left"]B[/TD]
[TD="align: right"]0[/TD]
[TD="align: left"]sum of sales[/TD]
[/TR]
[TR]
[TD="align: left"]B[/TD]
[TD="align: right"]1[/TD]
[TD="align: left"]sum of sales[/TD]
[/TR]
</tbody>[/TABLE]
Any idea how can i get the last table ?
Thanks in advance!