The UK tax year runs from eg 6 April 2018 to 5 April 2019 and I want to extract total from my dataset. I can use column date filtering but the filtered date ranges are not visible, nor is it intuitive to change them.
Ideally, I would like to have beginning and end dates showing in cells outside the pivot table, and for pivot table to filter based on those dates. Is there a way to do this (and without VBA)?
Ideally, I would like to have beginning and end dates showing in cells outside the pivot table, and for pivot table to filter based on those dates. Is there a way to do this (and without VBA)?