Creating a horizontal pivot table with column headers from rows

Copper Contributor

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?

 

2 Replies

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