• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SORT

N

niting

New Member
Hie forum,


I have a list of customer wise product wise sales. The customer is in col A and product is in Col B. for customer A, there can be 4-5 different products and the subtotal of sales made is shown.


Now the problem I have is that I want to sort the customer wise grand total sales with individual product wise sale also shown for the customer.


There are atleast 200 customers and I have tried things like pivot but not able to get the desired result.


Pls help me.


Thanks

Nitin
 
Amritansh,


Here is the link of the sample data sheet


https://www.dropbox.com/s/cwq7gu5av1y04wz/Sales%20Data.xls


Thanks

Nitin
 
Hi Nitin ,


You can find the answer here :


http://www.mrexcel.com/forum/excel-questions/11493-subtotals-ranking.html


Do Subtotal , on every change of Customer Code ; collapse the outlines so that only the subtotals are displayed ; sort on column E. Expand the outlines and your original data will be there in correct order.


Narayan
 
Hello Nitin,


You can achieve the desired format by adapting a pivot table.


Please check the attached file, hope this serves your need


https://www.dropbox.com/s/f9m0g5vl8znu7em/Sales%20Data.xls?m


Raja
 
You must log in or register to reply here.
Back
Top