I have reattached your workbook with a new sheet. I created two new calculations, %Number of Employees and KPI calc. I hope this helps!
Awesome that worked well - I thought I had done that but did not get what the results I expected. This is working fine.
Another obvious question - how do I insert dimensions into title text on a dashboard. I have a text container in my dashboard but can only see parameters for insertion???
A dashboard is a kind of blank canvas, so it doesn't have a way to know which members of what dimensions to choose out of all the possibilities. Parameters are global to the workbook, so that's why they are available for dashboard titles. The way around this is to create a worksheet that has the right filtering/sorting/etc. and format that to be your title.