Hello everybody,
My data looks like this :
OF | Quantity A | Quantity B |
15001 | 5 | 6 |
15002 | 4 | 4 |
15003 | 7 | 8 |
15004 | 9 | 8 |
And I would like to show it in a crosstab, this way :
(https://i.imgur.com/9uUdokX.png)
The problem is half of my rows are empty, even though the data exists :
(https://i.imgur.com/EqHbalT.png)
It's always the last quantity that I want to add to the crosstab that show up as empty. When I look at tabular data everything is here.
Here is what the outline looks like :
(https://i.imgur.com/eD3BHW6.png)
Any idea on what is causing this behavior ?