I need to examine via pivot a datasource from a sheet. This datasource sheet is something like this:
| Field 1 | Field 1 | Field 3 |
| AAAA | BBBB | CCCC |
| DDDD | EEEE | FFFF |
| GGGG | HHHH | IIII |
| KKKK | BBBB | LLLL |
My pivot table is such that Field 1 and Field 2 **must* be used as "row area" (on the left).
The problem is that since I've two different "group by" value for BBBB (i.e., AAAA+BBBB and KKKK+BBBB) I see two null-valued row for Field 1, one for AAAA and one for KKKK.
I understand the logic behind this, but I need a clearer way to identify then the null-value on field 1, such as, AAAA+BBBB and KKKK+BBBB.
Any hint?