• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dashboard pivot help

sms2luv

Member
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.
 

Attachments

  • Book1.xlsx
    13.1 KB · Views: 18
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!
 
Back
Top