Created attachment 198153 [details] Pivot table with wrong result for some values Hello, On the attached calc sheet, for the values indicated as Default, the pivot table shows a wrong result as you can see. Thank in advance for your support. Kind Regards Pierre Duvallet
If you tell us about wrong sum then there is a fundamental problem in Computer Science naming IEEE 754
And tdf#140806, it makes it difficult to improve data presentation, in cases like this.
Sum for 32,07 32,04 32,02 32,01 is 128,14. Pivot table is showing 128,14. What is exactly the problem? Remember that after the new data are inserted into a table, the pivot table need a right click - refresh.