Highlander Mc
New Member
- Joined
- Jun 11, 2016
- Messages
- 2
Hi
I'm trying to pivot the following scenario:
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
To give the following answer
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Currently my efforts just seem to stack the different Yes/No on top of each other. Is it possible to achieve the above?
I'm trying to pivot the following scenario:
Chairs | Tables | Carpets | |
Room 1 | Yes | Yes | Yes |
Room 2 | No | Yes | Yes |
Room 3 | No | No | Yes |
etc |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
To give the following answer
Yes | No | Total | |
Chairs | 1 | 2 | 3 |
Tables | 2 | 1 | 3 |
Carpets | 3 | 0 | 3 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Currently my efforts just seem to stack the different Yes/No on top of each other. Is it possible to achieve the above?