https://bugs.documentfoundation.org/show_bug.cgi?id=152608
Bug ID: 152608
Summary: Pivot table Displayed value % of Row shows wrong
result
Product: LibreOffice
Version: 7.4.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Selection of Displayed value "% of Row" in Pivot table in attached example
shows wrong result, in spite the Total column show 1100%.
Steps to Reproduce:
1. Open attached file and select data set A1:K601.
2. Select insert Pivot table and put Vietas ID2 into Row fields, Dziļums, cm
into Column fields and Paraugu masa, g in Data fields. In Column and Row
fields hide empty values.
3. For Data fields select average and % of Row in Displayed value.
Actual Results:
Values in table exceeds 100% in spite in Total column 100% is apearing
Expected Results:
Sum of values in row is 100%
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.4.3.2 / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: lv-LV (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
