Tripleseas
Board Regular
- Joined
- Jul 12, 2022
- Messages
- 87
- Office Version
- 2013
- Platform
- Windows
I have a dataset ( dummy data) that i want to analyze and crate a dashboard from it. My 3 categories that i need to create with pivot table are : table of target acheivement rate ( i have created it with calculated fields ) then table of evolution ( i did create it ) and last the table of production ( created also ) all these tables are connected to a slicer ( the produts). my problem is i want to have only one pivot table that is connected to a dropdown list maybe or something alse so that i can just choose wheter i want to see Target achivement rate or evolution or production all in one place. the reason why is i will have multiple criteria ( partners, regions and so on) and to have all theses tables would be messy. so ideally i can choose to see target achveient rate and only this would be shwon on the sheet and i can choose to see evolution and then only the table of evolution would be visible and so on. hope i was clear thanks
I can create three seperated sheets and every sheet would have its own tables and slicers but that would be too much. ideally is to have one sheet only.
I can create three seperated sheets and every sheet would have its own tables and slicers but that would be too much. ideally is to have one sheet only.