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

[vinieme12]

as Text!

[vinieme12]

Lets Break your Cross Table into two steps and try

First  load your fields and create a new key field

TABLE1:

LOAD

   *

RecNo() as newKey

From YourSource;

Left Join (TABLE1)

CROSSTAB(TAX_CODE,TAX,1)

newKey

Taxfield1

.

.

Taxfield9

Resident  TABLE1;

DROP FIELDS Taxfield1 , ,,,,,Taxfield9  from TABLE1;    //DROP ALL TAXfields that we will be crosstabbing

[narender123]

I have shown you in my question with 1_screenshot screen shot . You can see in that screenshot expression, I didn't use any variable.

So where you saw the variable??

Thanks

[sunny_talwar]

I don't see any variable, but what I am asking is that are you using this expression directly in your chart or are you saving the below expression in a variable and then using the variable in your chart?

I have seen this kind of behavior when the expression is saved in a variable and then the variable in used in the chart instead of using the expression directly. That was the reason I asked this.

[narender123]

No i am using this expression directly in chart.     

[sunny_talwar]

I guess it would be helpful if you can share a sample where you can replicate this issue

[vinieme12]

have u tried the above ?