Hi,
I group a date field into months, quarters and years .
When I use this field in a pivot table the first and last date options are the<Starting with date and the >ending date.
I do not want the starting date and ending date in the table.
How do I get rid of the satrt and end dates from the table. If I unselect the end date from the filter I miss a good bit of that months data from the report.
The attachment shows the starting with date in the table which I do not want.
When I group the date field checking or unchecking the starting and ending dates do not make a difference.
Bookmarks