https://bugs.documentfoundation.org/show_bug.cgi?id=152608
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #2 from Mike Kaganski <[email protected]> --- As explained in help for the Data Field dialog [1]: > % of row > > Each result is divided by the total result for its row in the pivot table. > If there are several data fields, the total for the result's data field is > used. > If there are subtotals with manually selected summary functions, the total > with > the data field's summary function is still used. This means that the percent value shown in the cell depends on the "total": first, the cells' *absolute* value and "total" is calculated, then the absolute value in each cell in the row is divided by the total, to get the percentage. And indeed, the absolute "total" for a row showing an average is the *total* average; and each cell's value is some local average, that may deviate from total in any direction, including a case when it's greater than the total average. When percentage is calculated from that, the percentage would be greater than the total. Again: the "total" here is not a sum of percentages in the row cells, but an average for the whole data used for the row. The values above and below 100% allows one to see easily, how much this cell deviates from the total average. This is much easier to see that 226% is 2.2+ times larger than the total average, compared to seeing '0.0377' in a cell, and having to scroll right to see the '0.0166' total average for the row, then evaluating the ratio (if one didn't use percentages). [1] https://help.libreoffice.org/7.4/en-US/text/scalc/01/12090105.html?DbPAR=CALC -- You are receiving this mail because: You are the assignee for the bug.
