I've a list which has something like this:
List Title Status
Title 1 Active
Title 2 Pending
Title 3 Active
Title 4 Closed
I need an Excel BI dashboard which should be dynamically changed according to the above list. I should a PI chart which should display percentage of Active users, percentage of pending users etc.
Can someone tell me how could i achieve this ?