In this Image, 20, 18, 20, 18 is record count of records created by each Manager. I am able to plot the same graph to show the records created by Users whose role is Manager but my requirement is that each bar show the record count of all the roles who reports to Manager. For example, Let's assume three Sales representative work under the Manager1, so the bar should show the record count data by adding the each sales representative record -> Manager1(Record Count) = Sales Rep1 + Sales Rep2 + Sales Rep3.
Here, If Manager creates any record its record should also be summed up -> Manager1(Record Count) = Manager1 + Sales Rep1 + Sales Rep2 + Sales Rep3
Can anyone suggest me how to achieve this requirement.
Thanks in advance.