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.
