Hi,
I'm working in Excel 2010 and I would like, to some extend, to replicate the Timeline Slicer of Excel 2013.
I have date field from which I have created 5 columns which checks if the date in column A is Today, Current Week, Current Month, Current Quarter and Current Year as shown in the screenshot below:
I would like to filter the data in a PivotTable using a slicer. However, as it is now I will end up with five slicers - one for each column.
Would it be possible to create a formula, that gathers the five columns into one - so I will only have one slicer like the one below?
I'm working in Excel 2010 and I would like, to some extend, to replicate the Timeline Slicer of Excel 2013.
I have date field from which I have created 5 columns which checks if the date in column A is Today, Current Week, Current Month, Current Quarter and Current Year as shown in the screenshot below:
I would like to filter the data in a PivotTable using a slicer. However, as it is now I will end up with five slicers - one for each column.
Would it be possible to create a formula, that gathers the five columns into one - so I will only have one slicer like the one below?