Forum Discussion

YolandaBL's avatar
YolandaBL
Copper Contributor
Jun 24, 2020
Solved

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 numeri...
excel
  • wsantos's avatar
    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/

     

YolandaBL's avatar
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's avatar
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).

Resources