Cross table wrong data

[narender123]

Hi All,

I have created a cross table and after that it is showing wrong amount as shown in attached 1_screenshot. In 1st screen shot the sum(TAX) is 342446699 but in real total amount should be 38049633.because 38049633 is the total amount of all tax code but cross table creating this total amount for each tax code individually and that's why it is showing wrong data. Please tell me why cross table showing wrong data??

Thanks,

Narender

[sergio0592]

Try this :

=aggr(sum({<FLAG={'B'}>}STATISTICAL_VALUE),TAX_CODE )

[sunny_talwar]

How does your script look where you have implemented the cross table?

[narender123]

Thanks Jean.

I know it will show right amount but my question is that why is showing wrong data ??

and how we can sort out this in script level not in chart level.??

[vinieme12]

Are You doing a Left join after your crosstable load??

This is the only thing that will cause your data rows to repeat for each fieldvalue

[narender123]

No I am not doing any Left join but I am doing concatenation after cross table.

[vinieme12]

can you post the script?

[narender123]

Please see below cross table.

[narender123]

Please see my reply for Sunny.

[sunny_talwar]

Are you using a variable as your expression? May be you have to remove the equal sign from the variable.