I have two Column Labels in my pivot table,(hoping to have about 5 or so) but it seems the data becomes stacked instead of separating the 2. I want my first column Label A to have its 4 columns underneath it without column b Overlapping.this is what i want it to do
| A | | B |
|good |Fair|Poor|Other|Good|Fair|poor|other|
This is what it does
|A|B|
|Good|Fair| |Poor|
Good|Fair| |Good|Fair|
| A | | B |
|good |Fair|Poor|Other|Good|Fair|poor|other|
This is what it does
|A|B|
|Good|Fair| |Poor|
Good|Fair| |Good|Fair|