Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have a table such as the below (a straight table or pivot), is there a way to get the % Headcount of specific locations, and not just overall Headcount globally?
I need "% of Location" populated without manually writing the Location in a set analysis.
% of Total HC I already have - SUM(Headcount) / SUM(Total(Headcount))
So now I need % of Location (text in red). Any way to do this? Much appreciated!
Location | Project | Headcount | % of Total HC | % of Location |
San Jose | Auto | 89 | 5% | 100% |
Chicago | Banking | 67 | 4% | 46% |
Chicago | Health | 78 | 5% | 54% |
Tampa | Health | 345 | 23% | 28% |
Tampa | Auto | 890 | 59% | 72% |
Buenos Aires | Banking | 42 | 3% | 100% |
- | Total | 1,511 | 100% | - |
Try this,
Dim: Location, Project
Exp:
Sum(Headcount)/Sum(TOTAL Headcount)
Sum(Headcount)/Sum(TOTAL <Location> Headcount)
Try this,
Dim: Location, Project
Exp:
Sum(Headcount)/Sum(TOTAL Headcount)
Sum(Headcount)/Sum(TOTAL <Location> Headcount)
This is literally exactly what I wanted to see - thank you so much! The real MVP!