Hello guys
I have a table looking like this:
<tbody>
</tbody>
And from this table I create a pivot table. The result I need to get is this:
<tbody>
</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
<tbody>
</tbody>
Any idea how can i get the last table ?
Thanks in advance!
I have a table looking like this:
Row | A | B | C | Sales |
1 | 1 | 0 | 1 | 22 |
2 | 0 | 0 | 0 | 103 |
3 | 1 | 1 | 1 | 113 |
4 | 1 | 1 | 1 | 77 |
5 | 1 | 0 | 0 | 109 |
6 | 0 | 0 | 1 | 101 |
<tbody>
</tbody>
And from this table I create a pivot table. The result I need to get is this:
A | B | Sum - Sales |
0 | 0 | 150 |
1 | 102 | |
1 | 0 | 345 |
1 | 268 | |
Total Result | 865 |
<tbody>
</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
A | 0 | sum of sales |
A | 1 | sum of sales |
B | 0 | sum of sales |
B | 1 | sum of sales |
<tbody>
</tbody>
Any idea how can i get the last table ?
Thanks in advance!