Formula to show/reference selected value by slicer/timeline

**Mau_rice89** · 09-05-2017, 11:49 AM

Hi,

I have a timeline connected to a pivot table.
So in my case: I select a month within a year, say februari 2016 and then I get total revenue februari 2016.

However I would also show the total revenue for year - 1, in my example februari 2015.

How can I manage to do this? See the image for an example, how it looks now.

example slicer.PNG

Thanks in advance,

**JeteMc** · 09-07-2017, 09:19 AM

Hello Mau_rice89 and Welcome to Excel Forum.
It would be easier to help if you would upload the workbook from which the screenshot is taken.
To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window. Make sure there is just enough data to demonstrate your need and remember to desensitize the data.
Let us know if you have any questions.

**Mau_rice89** · 10-17-2017, 10:51 AM

Hi,

Herewith the document + data.

So, I have a timeline connected to a pivot table.
So in my case: I select a month within a year, say december 2016 and then I get total revenue februari 2016.

However I would also show the total revenue for year - 1, in my example februari 2015.

How can I manage to do this?

Best,
Maurice