Excel - Sorting groups in groups due to subtotaling
I have not worked with pivot tables much, could you guide me?
Thanks again!!!
On Apr 2, 2:53*pm, wrote:
I need to know how tosortnumbers ingroupswhen they arewithingroupsdue to subtotaling.
I want to be able tosorteach company by descending order by Sales
number.
Here is an example:
Customer Name * Product Name * *Sales
ABC Company * * Product 1 * * * * * * * * * * * * 880
* * * * * * * * * * * * Product 2 * * * * * * * * * * * * 220
* * * * * * * * * * * * * * * * Product 3 * * * * * * * * * *400
Subtotal * * * * * * * * * * * * * * * * * * * * * * * *1,420
DEF Company * * Product 1 * * * * * * * * * * * *700
* * * * * * * * * * * * Product 2 * * * * * * * * * * * 1,250
* * * * * * * * * * * * * * * * Product 3 * * * * * * * * * *100
Subtotal * * * * * * * * * * * * * * * * * * * * * * * *2,050
I need to know (as they say) yesterday, if anyone can help!!!!!
Thanks!
|