DashboardNovice
Member
In my raw data, I have a list of names and dates (January through July). I created a column to extract the month from the dates column. In the "filters" box of the pivot table window, I have the months column, with January and February filtered out.
In the "rows" box of the pivot table window, I have the date field. When I select the pull down arrow on the date field, I see all dates from January through July. I was hoping to see March through July.
I tried PivotTable Options > Data > Number of items to return per field = None then I refreshed the pivot table and this still didn't work.
I would like the date field to show dates only from March to July (exclude January and February). How can I make this happen?
In the "rows" box of the pivot table window, I have the date field. When I select the pull down arrow on the date field, I see all dates from January through July. I was hoping to see March through July.
I tried PivotTable Options > Data > Number of items to return per field = None then I refreshed the pivot table and this still didn't work.
I would like the date field to show dates only from March to July (exclude January and February). How can I make this happen?