Cross table problem

[narender123]

Hi All,

I am using a cross table.

Like:-

TableA:

    DECLARATION_ID,

   CUSTOMS_VALUE

     ITEM_NO,

    EXPORT_DUTY_EXEMPTED,

     EXCISE_DUTY_EXEMPTED

FROM TABLEA;

Expression in report:

=Sum(CUSTOMS_VALUE) is showing right.

but when use cross table

CrossTable(TAX_CODE,TAX,3)

NEW:

LOAD DECLARATION_ID,

        CUSTOMS_VALUE

       ITEM_NO,

       EXPORT_DUTY_EXEMPTED,

       EXCISE_DUTY_EXEMPTED

RESIDENT TableA;

DROP TABLE TableA;

Expression in report:

=Sum(CUSTOMS_VALUE) is showing wrong.

Why after cross table CUSTOMS_VALUE is showing wrong??

Thanks,

Narender

[narender123]

Thanks for your reply.