This subreddit has been really helpful and helping me navigate some tricky areas of Excel and I really appreciate it. For this situation I decided to try and entertain everyone with a story.

I work for Hidden Identity Vegan Cupcake Company (HIVCC). Recently a rival company has come in, Superhero Vegan Cupcake Company (SHVCC). My boss wanted me to create a spreadsheet that compares the salary of employees at HIVCC to the employees at SHVCC. Basically, he wants every employee at SHVCC compared to all employees at HIVCC. I don't know why he wants to know how much more he makes than the peon at SHVCC, but he does. When I finished the spreadsheet, there are over 900 thousand lines, which of course my boss doesn't like. He now wants, on a different spreadsheet, a way to filter results however he wants, be it by specific person against a job title, or a job title against if the employee is salary or hourly (bi-weekly).

I created a spreadsheet example for everyone to manipulate and uploaded it to AWS. I hope this works. there are three tabs. One for hidden identity employees, one for superhero employees, and the third which uses power query to combine the results the way my boss wants it.

I thought a pivot table would work, but when I put the "difference percentage" column in results I'm not getting percentages from the power query tab.

I probably did a terrible job explaining what I'm trying to accomplish but will answer any questions to clarify anything. As always thank you for taking the time to looks at this and assist me.

I work for Hidden Identify Vegan this