shannonsmith
New Member
- Joined
- Apr 12, 2012
- Messages
- 37
I essentially need a formula that says for every market (there are 20), rank all of the products within that market by $ Vol (highest to lowest).
I've tried to filter on the markets and then rank the product, but the file becomes very slow because there are 20 Markets, each containing roughly 30,000 products. Any suggestions would be greatly appreciated.
<tbody>
</tbody>
I've tried to filter on the markets and then rank the product, but the file becomes very slow because there are 20 Markets, each containing roughly 30,000 products. Any suggestions would be greatly appreciated.
MKT | PROD | $ Vol |
Total Retail | SUTTER HOME 1.5 LITERS | $ 96,201,869.00 |
Total Retail | SUTTER HOME 187 MILLITERS | $ 57,751,044.00 |
Total Retail | SUTTER HOME 750 MILLITERS | $ 58,107,054.00 |
Total Retail | SUTTER HOME 3 LITERS | $ - |
Total Retail | SUTTER HOME | $ 212,059,967.00 |
Total Retail | BAREFOOT 1.5 LITERS | $ 153,541,287.00 |
Total Retail | BAREFOOT 187 MILLITERS | $ 17,358,324.00 |
Total Retail | BAREFOOT 750 MILLITERS | $ 188,904,750.00 |
Total Retail | BAREFOOT | $ 359,804,361.00 |
Total Retail | BRAND FAMILY | $ 571,864,328.00 |
TARGET TOTAL CTA | SUTTER HOME 1.5 LITERS | $ 2,177,572.00 |
TARGET TOTAL CTA | SUTTER HOME 187 MILLITERS | $ 2,388,573.00 |
TARGET TOTAL CTA | SUTTER HOME 750 MILLITERS | $ 1,296,227.00 |
TARGET TOTAL CTA | SUTTER HOME 3 LITERS | $ - |
TARGET TOTAL CTA | SUTTER HOME | $ 5,862,372.00 |
TARGET TOTAL CTA | BAREFOOT 1.5 LITERS | $ 4,749,233.00 |
TARGET TOTAL CTA | BAREFOOT 187 MILLITERS | $ 28.00 |
TARGET TOTAL CTA | BAREFOOT 750 MILLITERS | $ 5,933,944.00 |
TARGET TOTAL CTA | BAREFOOT | $ 10,683,205.00 |
<tbody>
</tbody>