+ Reply to Thread
Results 1 to 3 of 3

Formula to show/reference selected value by slicer/timeline

  1. #1
    Registered User
    Join Date
    09-05-2017
    Location
    Curacao
    MS-Off Ver
    2013
    Posts
    2

    Formula to show/reference selected value by slicer/timeline

    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,

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,816

    Re: Formula to show/reference selected value by slicer/timeline

    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.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    09-05-2017
    Location
    Curacao
    MS-Off Ver
    2013
    Posts
    2

    Re: Formula to show/reference selected value by slicer/timeline

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Can't Connect Slicer & Timeline To Two Pivot Tables
    By rahul_ferns76 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-28-2017, 04:11 AM
  2. timeline slicer for months only
    By zico8 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 10-26-2016, 03:30 AM
  3. [SOLVED] Timeline/Slicer refresh issue
    By PFDave in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-02-2016, 10:05 AM
  4. Timeline and Slicer Help
    By PFDave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2016, 06:44 AM
  5. Timeline slicer connection question
    By jugdish in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-19-2015, 02:19 PM
  6. Timeline Slicer showing more months than in data set
    By berkeleyjake in forum Excel General
    Replies: 3
    Last Post: 04-03-2015, 08:12 AM
  7. Timeline Slicer custom fiscal period
    By pinebush in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-16-2014, 10:57 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1