1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using Slicer values as column headers in another worksheet

Discussion in 'Excel Dashboards' started by eportal, Jan 5, 2018.

  1. eportal

    eportal New Member

    Messages:
    2
    Hello,

    I have a pivot table with slicers in Sheet1, and usually only one slicer is selected for Year and Month slicers, such as December, 2011.

    I'd like to be able to display the slicer values selected in a new worksheet (Sheet 2)as a column header, where December would be in one cell, and 2017 would be in another cell. I tried using the formula =Slicer_Master_Date.Month and =Slicer_Fiscal_Periods.Fiscal_Year in a cell in Sheet 2, but it returns a blank. I'd prefer not to hard code the values in Sheet 2, and when a user selects a different slicer value in Sheet 1, Sheet 2 is updated automatically.

    upload_2018-1-5_11-20-46.png

    upload_2018-1-5_11-21-23.png
  2. Chihiro

    Chihiro Excel Ninja

    Messages:
    4,751
    Upload sample workbook. That will help you in getting help.

    If unable to... try following method.

    Copy your pivot and put it into another sheet. But only with field used in slicer as row label. Connect that to your slicer. You can then just use the first cell of the row label range as reference for your cell.
    Thomas Kuriakose and Nightlytic like this.
  3. eportal

    eportal New Member

    Messages:
    2
    That works - thank you! I had created the separate pivot with just month and year, but forgot to connect it to the slicer on the Sheet 1.

Share This Page