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...
For these two fields setting Repeat item label is not set.
If only for one field to set
I didn't catch what an idea of such PivotTable which aggregates nothing, in attached file it's kept as it is with only one field changed.
SergeiBaklan I don't want the "Year", "Week No." or "Date" Columns to include "Repeat data in rows" as this is difficult to read with multiple date values in a large table. The attached workbook is an abridged version only.
Sorry, misunderstood the question.
As for same rows, PivotTable doesn't show exactly the same in Rows, it aggregates data for them in Values.