Paul, I have needed to find a MODE for a couple models now. The way I have been calculating the Mode is by turning the numbers into a text string concatenated with the dimensions that I need to find the mode across. i.e. Find the Mode of a Price by Product, by Territory. Step 1: Load File with unique ID name KEY ID Step 2: Concatenate Product&Territory&Text(Price) Step 3: Firstoccurence(Product&Territory&Text(Price), KEY ID) Step 4: Import concatenation of Product&Territory&Text(Price) into a new list name Mode List Step 5 Mode List Finditem: Finditem(Product&Territory&Text(Price), Mode List) Step 6: Add a line item with Formula = 1 and name it Count Step 7: Final Mode: Count[Sum: Mode List] Step 8: Run a Max Formula on Final Mode by Product by Territory Step 9: If Max = Final Mode then Sum Price by Product by Territory I understand that this takes a couple steps to run the mode, let me know if you have a simple method to run a mode across multiple dimensions! Thanks! Morgan
... View more
