How to get data from Pivot Table (data file enclosed)

[G MUTHU VEERAPPAN]

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.

[#2]

If you have some other solution, please guide 

[#3]

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.

[#4]

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

[#5]

Here is a solution with slicers and a second pivot table.