Forum Discussion
use results from filtered table
operations240 in the attached are 2 examples 1 pivot table and 1 example manual FILTER tables.
Since each of these are dynamic you really need to have the allocated hours in a table for lookup. In the attached I just added a column to the existing table for allocated hours. In the pivot table I added a calculated field for the difference in the manual I just did more calculations (lol). Hope this helps
m_tarler I tried a pivot table prior to making this post, but I am very rusty (haven't done a pivot table for many years!), and couldn't seem to get the hours to add up correctly no matter how I changed the output in the options.
This is a shot of the table I am using.
I want to be able to have an output that looks something like this:
I want to be able to filter the first table by caretaker name, and have the filtered cells be the output for the second table. The hours allocated to property will be populated manually, with the difference a simple calculation.
operations240 in the attached are 2 examples 1 pivot table and 1 example manual FILTER tables.
Since each of these are dynamic you really need to have the allocated hours in a table for lookup. In the attached I just added a column to the existing table for allocated hours. In the pivot table I added a calculated field for the difference in the manual I just did more calculations (lol). Hope this helps
m_tarler Many thanks for that; I was planning on setting up the allocated hours on a separate sheet, so many thanks for the help!