Error on Pivot Table

Thu, 27 May 2010 15:54:09 GMT

Dear all,

I have an error on pivot table and i dont know to solve

I have a table with data and one system variable.

On table are a lot of records, and I'm filtering them by that variable.

Table content is:

TR;FE;FS;ID

EX;01/01/2010;;1

EX;01/01/2010;01/02/2010;1

I have a pivot table with that sentence

=if([TR]='EX',count({$<[FS]={"$(Date)"}>} distinct [ID]),count({$<[FE]={"$(DATE)"}>} distinct [ID]))

On table example I have 170 that complains FS=Date,

It seems to be correct on that, but on total, on pivot table it shows total exp (248) and I have only 170.

Can someone help me?

Best regards

topic Error on Pivot Table in QlikView