I have a database that has a field called 'Posted Date', along with a number of other fields. I have produced a number of pivot tables to manioulate this data. To filter this data I have been using a Time Slicer on the 'Posted Date' field.
All of my pivot tables are in the same excel spreadsheet, but on different worksheets. What I need to be able to do is use a time slicer to filter 'Posted Date' one way on a worksheet, and a different way on another worksheet.
For example;
Sheet 1 - I time slice by the current month
Sheet 2 - I time slice by the past 12 months.
Both time slicers are labelled 'Posted Date', and seem to be linked in some way. What I mean here is that if I set the one on Sheet 1 to January, then the one on Sheet 2 is the same. If I change the one on Sheet 2 to a 12 month period, then the one on Sheet 1 becomes the same.
Is there a way round this, other than replicate the date field in my data model (which is just wrong).
Thanks in anticipation
Steve
All of my pivot tables are in the same excel spreadsheet, but on different worksheets. What I need to be able to do is use a time slicer to filter 'Posted Date' one way on a worksheet, and a different way on another worksheet.
For example;
Sheet 1 - I time slice by the current month
Sheet 2 - I time slice by the past 12 months.
Both time slicers are labelled 'Posted Date', and seem to be linked in some way. What I mean here is that if I set the one on Sheet 1 to January, then the one on Sheet 2 is the same. If I change the one on Sheet 2 to a 12 month period, then the one on Sheet 1 becomes the same.
Is there a way round this, other than replicate the date field in my data model (which is just wrong).
Thanks in anticipation
Steve