https://bugs.documentfoundation.org/show_bug.cgi?id=149003
Bug ID: 149003
Summary: Pivot table displays blanks instead of the sum of
calculated values from a query
Product: LibreOffice
Version: 7.3.3.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Trying to create a Pivot Table using a query as the source. The data to be
displayed is the sum of a calculated field in the query. The Pivot table picks
up the records but displays blanks where the sum of the calculated fields
should be. If I drill down on the data it displays the calculated fields
correctly. If I have a calc sheet with a calculated field and use these cells
as the pivot source then the sum of the calculated fields are displayed
correctly.
Steps to Reproduce:
1.Create a Base table with entries ID,Description,CreditValue,DebitValue
2.Create a query reporting Description,CreditValue,DebitValue and calculated
field Value which is equal to CreditValue - DebitValue
3.In Calc Create a Pivot Table using the above query as a source with the
Description in the Row Field and the sum of value in the data field.
Actual Results:
The row fields are populated correctly.
The associated data fields are all blank
Expected Results:
The data fields should be populated with the sum of the calculated fields from
the query
Reproducible: Always
User Profile Reset: No
Additional Info:
Work
Build d1d0ea68f081ee2800a922cac8f79445e4603348
OS: Mac OS X 10.16
--
You are receiving this mail because:
You are the assignee for the bug.
