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.
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 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
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.
|
With Regards,
Rajeshkannah Gopalakrishnan
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.
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.
