Dec 16 2019 12:28 PM
I have a dashboard that is a pivot table, and I'm trying to recreate it, but can't figure it out. In the rows area in the pivot table fields box, I have column headers from my source data. There is nothing in filters, columns, or values. I have a number of slicers to further sort the data. That allows people to slide the data any way they want. For instance, my pivot table looks like this if I use the slicers for season and store to pick fall and whole foods:
Fruit Season Farmer Store
Apple Fall Brown Whole Foods
Mango Fall Jones Whole Foods
When I try to recreate this table using the exact same thing, I get this:
Row Labels
Apples
Fall
Brown
Whole foods
Mango
Fall
Jones
Whole foods
I can't recall how I made the first dashboard. Can anyone help?
Dec 16 2019 02:35 PM
@Detlef Lewin, oops, I glanced at this earlier, but must've been too hurried. Thanks for pointing me back in this direction! Works like a charm.