Not able to Achieve Pivot Count Report Using PQGrid

[vijay@spinetechnologies]

Dear Team,
Using PQGrid We want to implement a Pivot count report. but we are not able to achieve the desired result.
Kindly guide us. we have used the count function of PQGrid.

We have attached screenshots for your reference.
PQGrid Result
Excel Pivot Result (Same data used)
Excel Sheet

The expected result is as per Excel Sheet Pivot Feature.

[paramvir]

Which version of pqgrid are you using?

I'm getting count as in screenshot. It shows same value as in Excel in pivot body.

But it shows different values in grand summary. Grand summary values in pivot for count aggregate would be fixed in next version.

[vijay@spinetechnologies]

We are using ParamQuery Pro v8.7.0

[vijay@spinetechnologies]

Dear Team,
Waiting for your reply to above Query.

[paramvir]

Dear Vijay

It's the same output in v8.7.0 as attached in earlier post.

Please share a jsfiddle if you are still getting incorrect count in the pivot body.