Hello everyone, I'm looking for help on how to get specific data into a pivot table and I can't seem to get it right. Basically, when a date/s are selected the specific repairs and their corresponding quantities are displayed. The ID and specialist columns aren't necessary. I'd also like to be able to group the repairs and quantities so for each date selected it shows the totals of all 3 repairs for each date, ie; if 2 weeks of dates were selected on the pivot table, it would show all asic, thermal reflows, unrepairable, etc for those specific dates.