This content has been marked as final. Show 2 replies
I have a data set like this.
....... ...... ........
I need to apply a ratio distribution on this Role to find out the ideal count of employees for this role.
PM:BA:DL:TL ratio should be 1:1:3:15
I want to display a graph which shows the ideal values applying this ratios against the roles..
Ideally the calculation should be ((1/20)*totalcount of emp name.There are some other filters active which will dynamically change the total count of emp name.Here how will I store the total count of emp name and how to create calculated field which shows the ideal values for different roles.