I'm relatively new to Anaplan having just completed the various training courses. I've been trying to figure this out for a couple of days using sum and lookup but seem to be encountering the same error "level mismatch". Here's my issue... I have a module that uses a numbered list as a dimension having three levels: Organization -> L1 -> L2 In the module I've calculated a line item value at that L2 level The combination of Org and L1 is my "parent hierarchy" list. L2 data is equivalent to data in a separate list. This other list is the dimension I'm trying to use in my new module attempting to aggregate the results of the first module as shown below. My objective is to create a secondary module that references the total amount at the L2 dimension value but sums up all of the values for the same L2. so, I have: Org L1 L2 value 1 x a 100 1 y a 200 1 x b 100 1 z b 300 What I want to be able to produce is: L2 value a 300 b 400 as indicated, the 'a' value in the second module is from a different list where the values in the list match the values in the L2 component of the originating module. As I said, I'm new to this whole game and I don't get much help from the very generic descriptions/examples in the help so I was hoping to turn to some more experienced users for some help using functions or combining functions to get this result
Solved! Go to Solution.