Hi everyone,
I have a spreadsheet that registers all Active Hardware Assets in our company.
I have two sheets. One for computers and the other one for other hardware (monitors, docking stations, printers, etc)
I want to be able to view in a separate sheet what hardware each individual user has.
I thought in creating a pivot table to link to both tables.. Currently my pivot table is filtering in the following order: Departments, Assigned to and Computer Name.
I want to be able to now incorporate the other hardware sheet into this pivot table, but it duplicates all the contents on that sheet into the pivot table instead of having a relationship of assigning all hardware to a specific name?
I wonder if a pivot table is actually useful for this situation (and if there is, what am i missing) or should i think about other options to have the end result that i require?
Thank you
I have a spreadsheet that registers all Active Hardware Assets in our company.
I have two sheets. One for computers and the other one for other hardware (monitors, docking stations, printers, etc)
I want to be able to view in a separate sheet what hardware each individual user has.
I thought in creating a pivot table to link to both tables.. Currently my pivot table is filtering in the following order: Departments, Assigned to and Computer Name.
I want to be able to now incorporate the other hardware sheet into this pivot table, but it duplicates all the contents on that sheet into the pivot table instead of having a relationship of assigning all hardware to a specific name?
I wonder if a pivot table is actually useful for this situation (and if there is, what am i missing) or should i think about other options to have the end result that i require?
Thank you