pivot table and dashboards

I am creating interactive dashboards by connecting pivot table and pivot charts reports to filters (called slicers or timelines). The problem I have is that I cannot generate pivot tables with numeric data fields on the rows. I thought I had done it one million times, but realized that what I was actually doing was transposing this kind of pivot table (fields in columns)

Into this (a non-pivot table with the fields as rows):

However, the second table is not a pivot table, so I cannot connect it to create an interactive dashboard. What I need is the SECOND TABLE with the fields as rows as a PIVOT TABLE.

Any help appreciated,

excel

wsantos
Jun 24, 2020
YolandaBL You can start from the first table, unpivot it first, then use it as a source for a regular pivot table: https://www.excel-university.com/unpivot-excel-data/

3 Replies

wsantos
Brass Contributor
Jun 24, 2020
YolandaBL You can start from the first table, unpivot it first, then use it as a source for a regular pivot table: https://www.excel-university.com/unpivot-excel-data/
- YolandaBL
  Copper Contributor
  Jun 24, 2020
  wsantosI have no words to express my gratitude. I was literally stuck and had tried all sort of tutorials and had almost given up. I have followed your instructions and it was easy. I am finally able to create the pivot tables the way I want and then insert the slicers for the dashboards. You haven't made my day, you have made my month! Truly grateful,
  Yolanda
  - wsantos
    Brass Contributor
    Jun 24, 2020
    YolandaBL Glad it worked - go have a caipirinha to celebrate (if you don't know what it is, it's something very useful during isolation).

Forum Discussion

pivot table and dashboards

3 Replies

Resources