Forum Discussion

Mrooney's avatar
Mrooney
Frequent Visitor
9 years ago
Solved

Use a column header as a slicer

Help this is driving me mad!   The powers that be are using a spreadsheet which shows project names along with timescales and then allocated hours per resource. The challenge is the resources are n...
Need Help
Tutorial Requests
  • Sean's avatar
    Sean
    9 years ago

    Mrooney

    1) Go to the Query Editor - select both Project Name and Timelines Columns - Transform tab - Unpivot Other Columns

    2) Rename Attribute column to Agent/Name (this will be your slicer Column) and Value column to Hours or sth...

    3) Home tab - Close & Apply

     

    Hope this helps! :smileyhappy:

Sean's avatar
Sean
Community Champion
9 years ago

Mrooney

1) Go to the Query Editor - select both Project Name and Timelines Columns - Transform tab - Unpivot Other Columns

2) Rename Attribute column to Agent/Name (this will be your slicer Column) and Value column to Hours or sth...

3) Home tab - Close & Apply

 

Hope this helps! :smileyhappy: