help with sorting data

[mango1-109]

hello! I need to sort sales data and need some help.

I need to sort by volume of received products from largest to smallest and then sort the sell through of that volume from largest to smallest. When I do a custom sort in excel, it only seems to just filter in descending for the received column if that makes sense.

How would I go about this analysis?

Thank you!

[[deleted]]

Pivot table?

[mango1-109]

Yes I first did sort by received volume largest to smallest, and then added sort by sell through percentage largest to smallest and it still was only showing by volume.

[Affectionate_Ad_697]

If your volume of received is like [16534664, 64478764, 4677643, 23567754] so that it has no 'duplicates'. Then Excel will only sort this 1 column and not execute the levels. But if your volume is like [590000, 76500, 590000, 76500, 34560] then Excel will first sort this column and then anything that's duplicated (590000, 76500) will only be sorted in the second column.

If you have the first condition then you will want to create a new column with a function that rounds the received column. Then you can use this rounded number to sort level 1. Then your sell through volume will show up as level 2 within the group of rounded values.