FRED_SHEET
New Member
- Joined
- Oct 13, 2017
- Messages
- 48
I have set up a Pivot Table based on a data source which has several column names which I have successfully used as filters to create Pivot Charts.
Page 15 of the book Microsoft Excel Pivot Table Data Crunching says this is not a good data source design.
" None of the column names in your data source double as data items that will be used as filters or query criteria (that is, names of months, dates, years, names of locations, or names of employees).
I am using years, months, and names of employees for filters with no problems, am I just lucky?
Page 15 of the book Microsoft Excel Pivot Table Data Crunching says this is not a good data source design.
" None of the column names in your data source double as data items that will be used as filters or query criteria (that is, names of months, dates, years, names of locations, or names of employees).
I am using years, months, and names of employees for filters with no problems, am I just lucky?