I am attempting to create a pivot table that shows a list of products (eg. mars, galaxy, kitkat) against the quantity (count) of a field containing invoice numbers, but the field contains several invoices that have the same number, so I would like the pivot table to show just unique numbers. (ie. I have 200 invoices but only 150 of them are unique numbers).
I know I can do this with advanced filtering or subtotals but ideally I would like to be able to do this in a pivot table. Does anyone know if this is possible? Thanks.