Comparing two pivot tables

Hey Guys,

Apologize if this questions been answered before, but I couldn't find anything. Basically what I want to do is to compare a column in one table to another column on the other table. Both the tables draw data from a separate sheet and I don't see a way I can tie them together to form one table which would make things a lot easier.

Column A / Column B = X % is the formula that I want to setup


If any other data/questions are needed please let me know & if this is an easy solution then sorry!

-Goose

Hello Goose,
Welcome to the forum.
I would have considered two options
1. Putting both the tables side by side and using match formula
2. If possible try and expore the possibility of merging source data and getting one Pivot table. This would require looking at sample data and pivot tables and also the desired output.
Best Regards/VKS

VKS,

Thanks for the input, I'll look into merging the source data and see how that works.

-Goose