Fields not showing actual result

[deepakqlikview_123]

Hello Team,

Please find attachment fields are not showing me actual results for April 2014 can you please suggest what would be condutions and filters in script.

Actual values are

Zone 1 should be  2652

Zone 2 should be  2377

Zone 3 should be  1051

Zone 4 should be  4251

Please suggest

Thanks,

[MK_QSL]

Dear Deepak,

You want count of Chassis Number for ZONE ID where IsCancelled = 0

Create a Table Box and try to add below

ZONEID

Chassis Number

Is Cancelled

Now create a pivot table... You will get the same result as per your QVW file.

If you want to get some different result means your isCancelled is calculated wrong in script side.