Allan Sabado
New Member
Hi Guys,
I don't even know if I have typed the title correctly however I would like to know if it is possible to create KPI dashboard that would should the overall/cumulative scores? I have seen some dashboards based on Pivot tables and its seems that in order to come up with the pivot, there should be no blanks in the data. Is that correct? Basically I am trying to come up with a dashboard which should show the overall KPI of the team, and on a click of a button(slicer perhaps) will narrow it down either by invididual, month(assuming that the data is only until February and the rest of the year is still empty) or Manager.
Appreciate if you could shed me some light into this matter.
I don't even know if I have typed the title correctly however I would like to know if it is possible to create KPI dashboard that would should the overall/cumulative scores? I have seen some dashboards based on Pivot tables and its seems that in order to come up with the pivot, there should be no blanks in the data. Is that correct? Basically I am trying to come up with a dashboard which should show the overall KPI of the team, and on a click of a button(slicer perhaps) will narrow it down either by invididual, month(assuming that the data is only until February and the rest of the year is still empty) or Manager.
Appreciate if you could shed me some light into this matter.
