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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pivot Tables Help
- Thread starter caaronh85
- Start date
