This content has been marked as final. Show 3 replies
Thanks for getting back to me. I think my question is a bit confusing, sorry. Hopefully this info clears things up some more:
- I am trying to find the average amount of complaints per staff member in a given region (Grand Total/Total Staff).
- So in my diagram above, it would be to show a column that would equal complaints per total staff members in a region, so 0.067 for North (200/3000), 0.076 for East (190/2500) etc.
- The staff numbers I have had to add 'manually' by use of a IF THEN calculation using parameters of the numbers (i.e. IF Region="North" THEN [North Staff Number]...)
- I'd like to be able to add more quarters or change the time period of the visualisation and it be able to automatically update the complaints per total staff members figure.
Hopefully this helps better explain what I am trying to do...
Many thanks for your reply!