Cross table showing wrong data

[narender123]

Hi All,

I have created a cross table like

Table1:

load

column1, column2,column3, column4,Value,VAT,SC,AD,BL

from table1;

Sum(Value)=100

Cross Table:

crosstable(Tax_Type,Total_Amount,5)

column1, column2,column3, column4,Value,VAT,SC,AD,BL

from table1;

Sum(Value)=80

When I take sum(Value) in normal table then it shows right data 100.But in cross table, sum(Value) shows wrong data  80 means less than original result.

Please tell me to sort out this??

Thanks,

Narender

[Anil_Babu_Samineni]

I am not purely sure i unerstand your requirement, but better moving forward try to share the excel and tell me which you are under stucked with image snap.

[avinashelite]

Do you have any null values in the data set ?? share the sample data so that we can understand the issue better