Dashboard pivot help

[sms2luv]

Hi team, I have made pivot table, which includes people scores.
I am creating s dashboard, which will list people who's score is less then 90%.
The dashboard will not contain pivot.
I will create a table with people who's scores are less, but how can I manage it, I mean should I use get pivot data or any other formula, the data keeps on updating.

File attached.

 

[chirayu]

You just need to add a Value filter on the Pivot. Less than or equal to 0.9

 

[rrocker1405]

Hi team, I have made pivot table, which includes people scores.
I am creating s dashboard, which will list people who's score is less then 90%.
The dashboard will not contain pivot.
I will create a table with people who's scores are less, but how can I manage it, I mean should I use get pivot data or any other formula, the data keeps on updating.

File attached.

Hi,

You can add the table to power pivot and create either a measure or kpi to list values as required.

Kind regards,
A!