Hello Everyone,
I am having problem in solving this pivot excel problem Need Help.
Sample Data of San Francisco Salaries:-
Question:-
1.) Add a calculated field named "% Other Pay" (Other Pay/Total Pay), formatted as a percentage with 1 decimal. How many job titles earned only Other pay in 2012?
2.) Among employees with >=$10k Base Pay in 2012, Did any employee earn more than 50% of their salary from Other Pay? If so, who?
Thank you
File Attachment is not working. I will attach file as soon as attachment start working...
Bookmarks