Hi, I have a straight table:
| Num | Store | Month | Count of A num | Sum of A linecost | Count of B num | Sum of B cost |
|---|
| WR | Sep | 1 | 357.5 | 0 | 0 |
| - | - | 0 | 0 | 4 | 0 |
| 34563 | TE | Sep | 1 | 624.7 | 1 | 624.7 |
| 25677 | WE | Sep | 1 | 236 | 1 | 426 |
| 25677 | CG | Sep | 2 | 765.9 | 2 | 765.9 |
| 54796 | WR | Sep | 1 | 1643.7 | 1 | 1643.7 |
| 24560 | HJ | Sep | 1 | 6432.8 | 1 | 6432.8 |
'A' and 'B' were from different tables but I joined them together. In both tables, there are no blank values for 'Num', so why are there blank boxes for 'Num' when I create the straight table?
Thanks.
