Forum Discussion
MichaelaMul
Helper III
Helper IIIRank Function
Hi everyone, I am trying to use the Rank function to then use as a filter on a multi-card to show Our Brands + the Top 3 by Volume Sales. How can I order it by Volume Sales and not the Size Name?...
Thanks for the input data.
I want to help you but your description is too vague and jumbled.
Considering deleting this post and starting from scratch.You will get a quicker and better response without misunderstandings if you put time and effort into carefully writing a clear problem description with example input and output data. Look forward to helping you when this information is forthcoming
* Please DO give a simple non-technical functional description of what you want
* Keep it simple and break large projects into smaller questions and ask just one question per ticket.
* Provide the example desired output, with a clear step-by-step description of calculations and the process flow.
* Remove any unneeded tables, rows or columns which may cause confusion. Keep it short and concise with the minimal information regarding the key problem.
* Avoid describing the problem in multiple, fragmented and conflicting posts. Try describe the problem with input data, output example and the step-by-step process in one post.
MichaelaMulHelper III
Helper IIIMy goal is to make a measure that ranks the Size Name by Volume Sales, filterable by Geography, Time, Concat Group. My goal is to use this measure in a multi-card visual to show Our Brand Size Names + the other Top 3 Size Names by Volume Sales.
Sample Data:
| Geography | Time | Size Name | Volume Sales | Price per Unit | Concat (groups) | OurBrand | Date | TotalSizeSales | Latest Week |
| Store A | Week Ending 07-13-25 | Our Product A 64oz | 51829 | 3.8166627756661*$ | Juice | 1 | 07-13-25 | 1709873.59 | FALSE |
| Store A | Week Ending 07-20-25 | Our Product A 64oz | 56903.5 | 3.62501 | Juice | 1 | 07-20-25 | 1709873.59 | TRUE |
| Store A | Week Ending 07-20-25 | Our Product A 96oz | 53373.75 | 4.851506 | Juice | 1 | 07-20-25 | 1460217.419 | TRUE |
| Store A | Week Ending 07-13-25 | Our Product A 96oz | 57115.5 | 4.773362 | Juice | 1 | 07-13-25 | 1460217.419 | FALSE |
| Store A | Week Ending 07-20-25 | PL A 64 OZ | 49322 | 2.819019 | Juice | 0 | 07-20-25 | 1333216.293 | TRUE |
| Store A | Week Ending 07-13-25 | PL A 64 OZ | 51059 | 2.797007 | Juice | 0 | 07-13-25 | 1333216.293 | FALSE |
| Store A | Week Ending 07-13-25 | S A 64 OZ | 29980.5 | 3.545167 | Juice | 0 | 07-13-25 | 888080.5089 | FALSE |
| Store A | Week Ending 07-20-25 | S A 64 OZ | 27995.5 | 3.620584 | Juice | 0 | 07-20-25 | 888080.5089 | TRUE |
| Store A | Week Ending 07-20-25 | PL A 96 OZ | 12795 | 3.743372 | Juice | 0 | 07-20-25 | 350656.3278 | TRUE |
| Store A | Week Ending 07-13-25 | PL A 96 OZ | 12662.25 | 3.653616 | Juice | 0 | 07-13-25 | 350656.3278 | FALSE |
| Store A | Week Ending 07-20-25 | C F AL 48 OZ | 12171.38 | 4.343198 | Juice | 0 | 07-20-25 | 294282.0495 | TRUE |
| Store A | Week Ending 07-13-25 | C F AL 48 OZ | 11218.13 | 4.613484 | Juice | 0 | 07-13-25 | 294282.0495 | FALSE |
| Store A | Week Ending 07-20-25 | S A 96 OZ | 3808.5 | 5.538405 | Juice | 0 | 07-20-25 | 182436.7589 | TRUE |
| Store A | Week Ending 07-13-25 | S A 96 OZ | 3931.5 | 5.494836 | Juice | 0 | 07-13-25 | 182436.7589 | FALSE |
| Store A | Week Ending 07-13-25 | S A 58 OZ | 2409.124 | 5.104584 | Juice | 0 | 07-13-25 | 75611.56717 | FALSE |
| Store A | Week Ending 07-20-25 | S A 58 OZ | 2280.533 | 5.130653 | Juice | 0 | 07-20-25 | 75611.56717 | TRUE |
| Store A | Week Ending 07-13-25 | R A 2 OZ | 2263.206 | 3.970062 | Juice | 0 | 07-13-25 | 48963.15768 | FALSE |
| Store A | Week Ending 07-20-25 | R A 2 OZ | 2188.635 | 4.089286 | Juice | 0 | 07-20-25 | 48963.15768 | TRUE |
| Store A | Week Ending 07-20-25 | M A 28 OZ | 1601.178 | 6.694758 | Juice | 0 | 07-20-25 | 44675.76272 | TRUE |
| Store A | Week Ending 07-13-25 | M A 28 OZ | 1729.833 | 6.569135 | Juice | 0 | 07-13-25 | 44675.76272 | FALSE |
| Store A | Week Ending 07-20-25 | C F AL 72 OZ | 802.6875 | 5.960498 | Juice | 0 | 07-20-25 | 21032.08821 | TRUE |
| Store A | Week Ending 07-13-25 | C F AL 72 OZ | 799.875 | 5.962011 | Juice | 0 | 07-13-25 | 21032.08821 | FALSE |
| Store B | Week Ending 07-13-25 | Our Product A 64oz | 62194.8 | 3.8166627756661*$ | Juice | 1 | 07-13-25 | 1709873.59 | FALSE |
| Store B | Week Ending 07-20-25 | Our Product A 64oz | 48367.98 | 3.62501 | Juice | 1 | 07-20-25 | 1709873.59 | TRUE |
| Store B | Week Ending 07-20-25 | Our Product A 96oz | 53373.75 | 4.851506 | Juice | 1 | 07-20-25 | 1460217.419 | TRUE |
| Store B | Week Ending 07-13-25 | Our Product A 96oz | 68538.6 | 4.773362 | Juice | 1 | 07-13-25 | 1460217.419 | FALSE |
| Store B | Week Ending 07-20-25 | PL A 64 OZ | 69050.8 | 2.819019 | Juice | 0 | 07-20-25 | 1333216.293 | TRUE |
| Store B | Week Ending 07-13-25 | PL A 64 OZ | 54122.54 | 2.797007 | Juice | 0 | 07-13-25 | 1333216.293 | FALSE |
| Store B | Week Ending 07-13-25 | S A 64 OZ | 28781.28 | 3.545167 | Juice | 0 | 07-13-25 | 888080.5089 | FALSE |
| Store B | Week Ending 07-20-25 | S A 64 OZ | 23796.18 | 3.620584 | Juice | 0 | 07-20-25 | 888080.5089 | TRUE |
| Store B | Week Ending 07-20-25 | PL A 96 OZ | 16633.5 | 3.743372 | Juice | 0 | 07-20-25 | 350656.3278 | TRUE |
| Store B | Week Ending 07-13-25 | PL A 96 OZ | 20259.6 | 3.653616 | Juice | 0 | 07-13-25 | 350656.3278 | FALSE |
| Store B | Week Ending 07-20-25 | C F AL 48 OZ | 13023.37 | 4.343198 | Juice | 0 | 07-20-25 | 294282.0495 | TRUE |
| Store B | Week Ending 07-13-25 | C F AL 48 OZ | 10545.04 | 4.613484 | Juice | 0 | 07-13-25 | 294282.0495 | FALSE |
| Store B | Week Ending 07-20-25 | S A 96 OZ | 2818.29 | 5.538405 | Juice | 0 | 07-20-25 | 182436.7589 | TRUE |
| Store B | Week Ending 07-13-25 | S A 96 OZ | 3774.24 | 5.494836 | Juice | 0 | 07-13-25 | 182436.7589 | FALSE |
| Store B | Week Ending 07-13-25 | S A 58 OZ | 2120.029 | 5.104584 | Juice | 0 | 07-13-25 | 75611.56717 | FALSE |
| Store B | Week Ending 07-20-25 | S A 58 OZ | 4333.013 | 5.130653 | Juice | 0 | 07-20-25 | 75611.56717 | TRUE |
| Store B | Week Ending 07-13-25 | R A 2 OZ | 1471.084 | 3.970062 | Juice | 0 | 07-13-25 | 48963.15768 | FALSE |
| Store B | Week Ending 07-20-25 | R A 2 OZ | 2407.499 | 4.089286 | Juice | 0 | 07-20-25 | 48963.15768 | TRUE |
| Store B | Week Ending 07-20-25 | M A 28 OZ | 2401.768 | 6.694758 | Juice | 0 | 07-20-25 | 44675.76272 | TRUE |
| Store B | Week Ending 07-13-25 | M A 28 OZ | 2110.396 | 6.569135 | Juice | 0 | 07-13-25 | 44675.76272 | FALSE |
| Store B | Week Ending 07-20-25 | C F AL 72 OZ | 794.6606 | 5.960498 | Juice | 0 | 07-20-25 | 21032.08821 | TRUE |
| Store B | Week Ending 07-13-25 | C F AL 72 OZ | 1039.838 | 5.962011 | Juice | 0 | 07-13-25 | 21032.08821 | FALSE |
| Store C | Week Ending 07-13-25 | Our Product A 64oz | 74633.76 | 3.8166627756661*$ | Juice | 1 | 07-13-25 | 1709873.59 | FALSE |
| Store C | Week Ending 07-20-25 | Our Product A 64oz | 41112.78 | 3.62501 | Juice | 1 | 07-20-25 | 1709873.59 | TRUE |
| Store C | Week Ending 07-20-25 | Our Product A 96oz | 53373.75 | 4.851506 | Juice | 1 | 07-20-25 | 1460217.419 | TRUE |
| Store C | Week Ending 07-13-25 | Our Product A 96oz | 82246.32 | 4.773362 | Juice | 1 | 07-13-25 | 1460217.419 | FALSE |
| Store C | Week Ending 07-20-25 | PL A 64 OZ | 96671.12 | 2.819019 | Juice | 0 | 07-20-25 | 1333216.293 | TRUE |
| Store C | Week Ending 07-13-25 | PL A 64 OZ | 57369.89 | 2.797007 | Juice | 0 | 07-13-25 | 1333216.293 | FALSE |
| Store C | Week Ending 07-13-25 | S A 64 OZ | 27630.03 | 3.545167 | Juice | 0 | 07-13-25 | 888080.5089 | FALSE |
| Store C | Week Ending 07-20-25 | S A 64 OZ | 20226.75 | 3.620584 | Juice | 0 | 07-20-25 | 888080.5089 | TRUE |
| Store C | Week Ending 07-20-25 | PL A 96 OZ | 21623.55 | 3.743372 | Juice | 0 | 07-20-25 | 350656.3278 | TRUE |
| Store C | Week Ending 07-13-25 | PL A 96 OZ | 32415.36 | 3.653616 | Juice | 0 | 07-13-25 | 350656.3278 | FALSE |
| Store C | Week Ending 07-20-25 | C F AL 48 OZ | 13935.01 | 4.343198 | Juice | 0 | 07-20-25 | 294282.0495 | TRUE |
| Store C | Week Ending 07-13-25 | C F AL 48 OZ | 9912.335 | 4.613484 | Juice | 0 | 07-13-25 | 294282.0495 | FALSE |
| Store C | Week Ending 07-20-25 | S A 96 OZ | 2085.535 | 5.538405 | Juice | 0 | 07-20-25 | 182436.7589 | TRUE |
| Store C | Week Ending 07-13-25 | S A 96 OZ | 3623.27 | 5.494836 | Juice | 0 | 07-13-25 | 182436.7589 | FALSE |
| Store C | Week Ending 07-13-25 | S A 58 OZ | 1865.626 | 5.104584 | Juice | 0 | 07-13-25 | 75611.56717 | FALSE |
| Store C | Week Ending 07-20-25 | S A 58 OZ | 8232.725 | 5.130653 | Juice | 0 | 07-20-25 | 75611.56717 | TRUE |
| Store C | Week Ending 07-13-25 | R A 2 OZ | 956.2047 | 3.970062 | Juice | 0 | 07-13-25 | 48963.15768 | FALSE |
| Store C | Week Ending 07-20-25 | R A 2 OZ | 2648.249 | 4.089286 | Juice | 0 | 07-20-25 | 48963.15768 | TRUE |
| Store C | Week Ending 07-20-25 | M A 28 OZ | 3602.651 | 6.694758 | Juice | 0 | 07-20-25 | 44675.76272 | TRUE |
| Store C | Week Ending 07-13-25 | M A 28 OZ | 2574.683 | 6.569135 | Juice | 0 | 07-13-25 | 44675.76272 | FALSE |
| Store C | Week Ending 07-20-25 | C F AL 72 OZ | 786.714 | 5.960498 | Juice | 0 | 07-20-25 | 21032.08821 | TRUE |
| Store C | Week Ending 07-13-25 | C F AL 72 OZ | 1351.789 | 5.962011 | Juice | 0 | 07-13-25 | 21032.08821 | FALSE |