If you are unable to create a new account, please email support@bspsoftware.com

 

Crosstab quantity contents are not consistent with the quantiy listed (table)

Started by limkw, 29 Apr 2015 10:06:42 PM

Previous topic - Next topic

limkw

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.