BUG: AllowDataCompression=TRUE makes a mess in aggregation

[Yi Han]

Hi,

with the uploaded sample, you can reproduce a bug in pivot table when AllowDataCompression=true.

Switch from Sum to Avg on column ExecNom -> the avg is not calculated

With Sum:

With Avg => Avg is not calculated, the number remains the calculation of Sum; and another column PerfVsVWAP reset to 0 !

When you set  AllowDataCompression=false, every thing is ok.

Are you aware there is bug on data compression ?

Thanks

Yi

[Yi Han]

with attachment:

Attachment: PivotTableAllowDataCompressionBug_eb8486cd.zip

[Rajeshkannah G]

Hi Yi Han,

Please find the response below

Query	Comments
“Switch from Sum to Avg on column ExecNom -> the average is not calculated”	We would like to inform you that the pivot table does not support the "Average" aggregation type when the data compression option is enabled. Please see our UG document below for more information on data compression limitations.   Document : https://blazor.syncfusion.com/documentation/pivot-table/virtual-scrolling#data-compression
“another column PerfVsVWAP reset to 0 “	We have considered this as a bug “Pivot Table values not displayed properly while changing aggregation type during AllowDataCompression enabled”. And this fix will be available in our December last weekly release, which is estimated to be rolled out at Dec 28, 2022.  The following feedback link will help you keep track of it.   Feedback Link:  https://www.syncfusion.com/feedback/39769/pivot-table-values-not-displayed-properly-while-changing-aggregation-type-during

With Regards,

Rajeshkannah Gopalakrishnan

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Yi Han,

We are glad to announce that our weekly Release V20.4.40 is rolled out and fix for the issue “Pivot Table values not displayed properly while changing aggregation type during AllowDataCompression enabled” has been included in this release. Please refer to the following sample.

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/PivotTableAllowDataCompressionBug_eb8486cd-1727272250

Output screenshot:

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.

Regards,

Angelin Faith Sheeba.