Hi, I have a system generated list of all our receivings.
I'm looking for a quick way to look up a specific invoice number. But to scroll through the list of 100's of invoice numbers takes to long.
I have tried adding a second pivot table and using the trick of the pull down filter. But it seems to be slow as I have several linked tables and several slicers each dependent on the next.
But to select the location, then the vendor and then the invoice number is very slow. But that does filter the invoices numbers on the list with each selection.
But maybe if I add a text box that the staff could just type in the invoice number and that would ALSO filter the list. It might speed things up.
Anyone with a suggestion?
Thanks
I'm looking for a quick way to look up a specific invoice number. But to scroll through the list of 100's of invoice numbers takes to long.
I have tried adding a second pivot table and using the trick of the pull down filter. But it seems to be slow as I have several linked tables and several slicers each dependent on the next.
But to select the location, then the vendor and then the invoice number is very slow. But that does filter the invoices numbers on the list with each selection.
But maybe if I add a text box that the staff could just type in the invoice number and that would ALSO filter the list. It might speed things up.
Anyone with a suggestion?
Thanks
