So, i have an invoice i am working out. I am using a pivot to calculate the "billable hours" from a timepunch data dump out of our pay system. The employees are organized by department, and display name, time in, time out, and hours.
On another sheet i have an invoice. On this invoice is a drop down list containing a list of our clients. When you select a client, the invoice populates with that clients data (address, etc).
What i would like, though, is when you select the client, the pivot will automatically display the departments that work for that client (since we parse our labor departments by which client we bill their labor to). This would make invoicing rather simple, as the manager would then just select a client from a drop down list, and print the invoicing (the invoice includes the invoice, as well as the punch information as a "labor detail" backup).
So, i guess the help i need is in understanding how i can reference a list of departments (which vary in number from client to client) that are tied to our clients as a conditional filtering argument in the pivot table.
On another sheet i have an invoice. On this invoice is a drop down list containing a list of our clients. When you select a client, the invoice populates with that clients data (address, etc).
What i would like, though, is when you select the client, the pivot will automatically display the departments that work for that client (since we parse our labor departments by which client we bill their labor to). This would make invoicing rather simple, as the manager would then just select a client from a drop down list, and print the invoicing (the invoice includes the invoice, as well as the punch information as a "labor detail" backup).
So, i guess the help i need is in understanding how i can reference a list of departments (which vary in number from client to client) that are tied to our clients as a conditional filtering argument in the pivot table.