0

I'm creating a dashboard for a company with multiple employees at multiple locations. They want a schedule with slicers that shows them different locations or specific employee schedules. I'm wondering if something like this is possible using pivot tables? I want to be able to view each location of their stores separately which slicers would be perfect for but I can't seem to get a pivot table to look like the example given.

Any help would be greatly appreciated.

Zach Shaner
  • 43
  • 9
  • @pnuts is it possible period? Doesn't need to be just a pivot table that was just the first thought that came into my mind. – Zach Shaner Jun 27 '17 at 20:01
  • @pnuts Do you have any suggestions on where to start? Or what resources tackle a similar problem? – Zach Shaner Jun 27 '17 at 20:26
  • Where is the underlying data? In a PivotTable? If so, you could use the GETPIVOTDATA function to dynamically populate those cells in a way that would respond to slicers. But the devil is in the detail – jeffreyweir Jun 28 '17 at 00:21

0 Answers0