Whoever in this community who have any idea how to fix the issue I am seeing on Crosstab output. If you open the excel spreadsheet, you will see 2 crosstab table, the first table on the column on 242x and 'E', 'F', 'I', 'U' the quantity as compared to the second crosstab table are not the same. if you take the 2 crosstab table quantity and compare it on the table below the crosstab, there is many quantity missing on the crosstab.
I have no idea why the crosstab have missing quantity, anyone have any idea what I need to do to resolve the inconsistent data shown on the crosstab?
I manually create the pivot table on the excel spreadsheet on month of Jan, that suppose to be the output results for the crosstab table.