I have data that looks like:
| Category | Item | Defect |
| AAA | 1 | Burnt |
| AAA | 2 | Burnt |
| BBB | 4 | Bad Weld |
| BBB | 2 | Broken Bolt |
| CCC | 1 | Burr |
| CCC | 3 | Broken Bolt |
| CCC | 5 | Broken Bolt |
I've created a sectioned Pivot Table:
Category AAA
| Defect | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Total |
|---|
| Burnt | 1 | 1 | | | | 2 |
Category BBB
| Defect | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Total |
|---|
| Bad Weld | | | | 1 | | 1 |
| Broken Bolt | | 1 | | | | 1 |
...
What I'm looking to do is suppress the columns that don't have data by section. So section AAA should only show columns for Item 1 and Item 2. Section BBB should only show columns for Item 2 and Item 4. And then section CCC should only show columns for item 3 and 5.
Is there any way to do that? Items and sections vary by day, so we can't use any solution that would make the columns static. The rows are dynamic by the section, so why can't I make the columns do the same?
Thanks,
Jessica
