Forum Discussion
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...
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/
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