Wrong number of Count

[nikhilgarg]

HEy,

I ahve an issue. When i am fetching count(OrderId) from table1 where salespersonname = 'name1' and OrderSystem in ('abc' , 'def') ;

Then it gives output say 612.

Now in Pivot table when i make expression as :

Count(OrderId) then it is giving me wrong count for that same person for which i executed query above.

Plz Help.

THanks

[sagarkharpude]

share your app.

[nikhilgarg]

Hey,

Actually i cannot share the dashboard. I am working on VDI.

[#4]

Hi,

don't send existing app but you can send a sample of records with that chart.

Regards

Vimlesh