So I have this table and I want to cross tab it.
Store | Total Sales |
A | 100 |
B | 200 |
C | 300 |
D | 400 |
So that I get this table.
A | B | C | D |
100 | 200 | 300 | 400 |
But what I am getting after using the cross tab and grouping by store is this
A | B | C | D |
100 | Null() | Null() | Null() |
Null() | 200 | Null() | Null() |
Null() | Null() | 300 | Null() |
Null() | Null() | Null() | 400 |
Im not too sure what I am doing wrong.
Solved! Go to Solution.