Forum Discussion
Missing values in pivot table
Hello, Downloaded my data, inserted pivot table, report layout is tabular form. Everything looked good until I noticed some missing values where there should be values. I verified the information th...
Riny_van_Eekelen Sorry. These are already ticked in the field settings box. I have tried this in the design/report layout tab for the whole table, but this just shows the year and week duplicated (which I don't want) and not the missing values. I have attached a copy of the workbook so you can see.
Windward By the way, what an awkward pivot table, using the Total Amount field as one of the row headers.