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
Please could you attach those sample files?
My first time logging a "Bug". Attempting to close the log as "fixed". Baffled with events. In the process of replicating and sending attachments I set up a new database and query and tried to do what I had a problem with on my "live" database. This time all ok.......! Test database and query OK under 7.3.3.2, "live" under previous version. All OK now