How to make Pivot table show when above KPI are selected

[heer1999]

Is there a way to make pivot table selectable. Let`s say I want to choose above kpi button and it only shows me data for the selection only.

[G3S]

you can click on those headings in the pivot and it will select those.

is this what you are asking?

[heer1999]

Thanks for your prompt response!

Let's say I click on the risk status changes button, I only wanna see Risk number with risk status changes in Pivot table and when I click on inherent button, I only want to see risk numbers with inherent rating.

Does that makes sense?

[G3S]

this is how I understand it:

the image you showed is multiple KPI buttons and when you click on one of those, you want the pivot to show only the values for that. 

add all of the KPI as values in the pivot. and when you select a particular KPI, only that will show in the pivot.