I am trying to develop a Pivot Table report that groups the dates in it's data in Months of the Year.
For example there will be a list of transactions each with it's own date attached.
What I want the report to do is allow me to pick a month as the filter and then only show data where the date falls in that month.
At the moment it is only allowing me to pick the individual dates.
I do have other fields that I need to filter by as well so any help appreciated.