Need help on sorting or grouping for printing

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.

No standard format. But I need by customer wise, at the end of each customer just I need the total of all the columns like that.

Originally Posted by vsravi.kmb

No standard format. But I need by customer wise, at the end of each customer just I need the total of all the columns like that.

Friends,

I need your help.