Hi!
I have no idea how to create a certain formula. I need to ultimately find the percentage of people in the same business sitting on a floor in a building. For example:
If the business is "Controllers" then I need to know out of all the controllers what is the percentage of them that sit on floor 4 of BP1.
There are several different floors, buildings, and businesses. I need to be able to calculate this for all businesses.
I appreciate any help or advice I can I get. I am attaching a small portion of my document so you can kind of see the data I am working with.
Thank you!
Bookmarks