I have a module with 3 or more lists, and Value and Rank line item. I want to rank Value for each combination of items in those 3 lists. However, I find that RANK function can only accommodate 1 list in the Group option.
Let's say I have a module of 3 lists: List1, List2, List3. The module line item is 'Value'
Items in List 1: Item 11, Item 12
Items in List 2: Item 21, Item 22, Item 23
Items in List 3: Product 1, Product 2, ..., Product 100
I want to find the Top 10 products for each combination of items in List 1 and List 2
However, the RANK function only allows one list for the 5th parameter which is the Group parameter. If I use RANK(p1,p2,p3,p4,ITEM(List 1)), the rank will take into account all items in List 1 and List 3, creating rank from 1 to 300 (3 x 100), and vice versa if I use RANK(p1,p2,p3,p4,ITEM(List 2)), the rank created will be from 1 to 200