ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: vijay@spinetechnologies on August 04, 2023, 03:35:29 pm

Title: Not able to Achieve Pivot Count Report Using PQGrid
Post by: vijay@spinetechnologies on August 04, 2023, 03:35:29 pm

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.

Title: Re: Not able to Achieve Pivot Count Report Using PQGrid
Post by: paramvir on August 07, 2023, 07:02:52 pm

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.

Title: Re: Not able to Achieve Pivot Count Report Using PQGrid
Post by: vijay@spinetechnologies on August 09, 2023, 05:24:46 pm

We are using ParamQuery Pro v8.7.0

Title: Re: Not able to Achieve Pivot Count Report Using PQGrid
Post by: vijay@spinetechnologies on August 11, 2023, 12:51:04 pm

Dear Team,
Waiting for your reply to above Query.

Title: Re: Not able to Achieve Pivot Count Report Using PQGrid
Post by: paramvir on August 11, 2023, 01:07:07 pm

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.