• 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...

  • 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

eportal

New Member
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
 

Chihiro

Excel Ninja
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.
 

eportal

New Member
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.
 
Top