Forum Discussion
How to get data from Pivot Table (data file enclosed)
Dear All, I have one Pivot Table in which all fields are in "ROWs" section.
What I need is to extract information of Data_Bank fields which have "Ongoing" status in corresponding "Data_Organized" Field.
Hello,
you can filter the pivot table. But you don't need a pivot table to get this information because you could also filter the source data.
Or you could throw the source data into Power Query and filter there.
Hi, I dont know about power query. Can you show in my file (uploaded one). I want to use this quick information my Dashboard. Thanks
Here is a solution with slicers and a second pivot table.
If you have some other solution, please guide
