I have a parameter with which a user using the dashboard can select one agent at a time to see the sales. I want to know a way where I can also populate avg sales of overall staff for comparison.
I didnt want to create two seperate sheets and show them on dashboard. I wanted it to be in one sheet in line graph.
3 个回答
@Said Tojiboev ,
Hi Saidjon,
Thank You for the response, the solution works but it gives me an same average for all the months. The average does not change for month to month.
Above is the case for time logged. The formula gives average for the entire time and not for the months
