Hello dears,
I need assistance with Pivot table.
https://file.io/m7n8EUQLlAf4
1. In attached file, in dashboard I want to convert my table from sheet "Data" to pivot table with same columns and rows. And put it to "Dashboard" sheet.
2. All slicers on sheet "Dashboard" on the left: "Status", "Risk assessment" and "Object" to be connected with the converted table.
3. 2 Pie charts on the top to be connected with slicers and dashboard.
I know, maybe I'm asking too much. I'm beginner in Excel and tried myself, even asked AI Copilot to help, but no result.
Appreciate your assist!
