We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

BUG: AllowDataCompression=TRUE makes a mess in aggregation


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 ?



3 Replies

YH Yi Han December 13, 2022 10:03 PM UTC

RG Rajeshkannah G Syncfusion Team December 14, 2022 10:17 AM UTC

Hi Yi Han,

Please find the response below



“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

AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team December 28, 2022 04:05 PM UTC

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 enabledhas 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.


Angelin Faith Sheeba.

Live Chat Icon For mobile
Up arrow icon