The total row is just completing whichever calculation you give it on an aggregate level. So when you have sum(staffing_level) / count(distinct ifnull(empID,1)), your total row is doing 4+4+4+6+6+6+2 = 32 / 7 = 4.57.
This is why in one of my first posts I mentioned you may want to create an "All Corporate" department, which has the totals already calculated. You can then put together a table like the attached image using MAX(staffing_level) and MAX(no_employees) as your two fields.
Hope this helps,
It is important that the totals remain calculated on the fly due to PDP policies and applying card filters. I was able to create the card with the correct totals and the drill down functionality by editing my dataflow to stage the data differently so I could sum all of the fields.
Thank you all for the feedback and ideas. I love to use the Dojo as a sounding board when I get stuck!
Can you make the replies that best helped you by clicking on Accept as Solution so others can benefit from this thread.