Need help on sorting or grouping for printing
I have a file for daily sales for the whole month. I have around 40-50 customers. At the end of the end I want take a print out for each customer how much sales done and how much balance etc. I will doit for each customer separartely and take a print out. But it will end up in so many pages. I need a simplified method for sorting for each customer so that I can print it out all together to save paper.
I have tried pivot table wizard, grouping sorting etc, none of them work for me
I have attached the file for your reference. At the end I have just filtered for one customer.
I need a help.