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