Ranking based on % ttl

[Laxkoss1287]

Hi,

I have a database of sales data (sorted in no particular order) that I want to indicate as "core" once I hit 50% of the sales total. I'd also like to add a secondary factor in labeling the items by classification (i.e. Only sumif the class=pants). Someone please help!

CLASSIFICATION SALES CORE
24 - SWEATERS 7005
24 - SWEATERS 6926
24 - SWEATERS 6136
24 - SWEATERS 5657
24 - SWEATERS 5325
24 - SWEATERS 5214
24 - SWEATERS 5160
24 - SWEATERS 3922
24 - SWEATERS 3138
24 - SWEATERS 1793
24 - SWEATERS 1720
24 - SWEATERS 1673
24 - SWEATERS 1028
24 - SWEATERS 979
24 - SWEATERS 565
24 - SWEATERS 409
24 - SWEATERS 267
24 - SWEATERS 50
24 - SWEATERS 25
24 - SWEATERS 0
21 - KNIT TOPS 78140
21 - KNIT TOPS 42853
21 - KNIT TOPS 26566
21 - KNIT TOPS 25708

[Sam Capricci]

You'll probable get more help if you upload a sample of data with examples and outcomes. Go advanced to upload it.