Forum Discussion
Missing values in pivot table
CSRouse What do you get when you double click the "0.00" on the second row of the pivot table (column "Sum of NetReportAmount1"?
I noticed when I formatted the pivot table in compact form the accounts missing the descriptions show up as indicated in the attached snip In this case accounts 110420 and 110846.Riny_van_Eekelen
CSRouse Difficult to diagnose on the basis of a picture alone! Can you upload a file?
Riny_van_EekelenI have been having the same issue. I have a data table with various date/text columns and an amount column. Where there is an entry with two duplicates either in the date, the text or the amount row, these sometimes appear with blank data or missing entirely. I have included screenshots of the data table, the pivot table with the data missing and one with the text amended to make the data show. This is totally impractical for the main pivot tables as there are duplicate monthly amounts for various accounts and I am having to amend each entry in the data table to ensure they show.
I have tried to change the field settings for "Repeat item lables" for the whole table in the "Design" Tab, but this doesn't work.
