Hi All,
I have two pivot tables with data. I need a formula to calculate the % of vacant units (right pivot) vs. total units (left pivot).
I need the formula to be dynamic as I change the top line filter to ensure it's pulling the correct comparison for the ID's.
I am attaching the pivot tables with the relevant data. Please let me know if there is anything else you require.
Thanks in advance for your help!
Bookmarks