Hi Guys,
I am trying to build a cash forecasting model for payments to suppliers.
I am basically extracting aged creditors with various currencies as my data and need to be able to quickly show values payable by currency as at certain dates. I have used pivot to display information as required and in the filter option on pivot wizard I have selected due date to be able to quickly filter between whatever dates are required (i.e. my management team ask for). I would then hope to filter on this to be able to quickly filter by year, months and days to show amount payable in each currency upto that due date (as picked in due date filter on pivot)
My problem is the filter function is not displaying dates in the pivot as it does in the data sheet (see screenshots to try and explain)
Data Filter
Data Filter.PNG
Pivot Filter
Pivot Filter.PNG
How can I get it so I can expand on year, months and days on pivot filter as it would on filter function on the data sheet?
Any help would be greatly appreciated.
Bookmarks