Hi All,

I have been working on preparing the data and am now trying to create a dashboard from it. Could you please assist me in building a dashboard that shows the monthly data for each individual, as well as the total achieved targets for the year?Picture 1: Data is divided into different verticals of Instore , Delivery, Ecom , Relationship Visits. That every individual have to achieve in a month. Relation ship target is based on the working days a team member is in office.Picture 2: Here is the rest of the data. i have total the all months in last.Picture 3: Here is the Pivots that are connected to Picture 1 and 2. From here i have applied Iferror to get data showed in picture 1 & 2.

​Hi All, I have been working on preparing the data and am now trying to create a dashboard from it. Could you please assist me in building a dashboard that shows the monthly data for each individual, as well as the total achieved targets for the year?Picture 1: Data is divided into different verticals of Instore , Delivery, Ecom , Relationship Visits. That every individual have to achieve in a month. Relation ship target is based on the working days a team member is in office.Picture 2: Here is the rest of the data. i have total the all months in last.Picture 3: Here is the Pivots that are connected to Picture 1 and 2. From here i have applied Iferror to get data showed in picture 1 & 2.  Read More

​