Hi, I keep getting the error "Dimension of mapping used for lookup doesn't match any dimension of the result".
Hello @AnnieMa ,
It looks like your dimension in REV05 is G2 Country rather than G3T Territory?
Would that be true? If so, I believe you should change them.
Cheers!
Hi @AnnieMa ,
As I can see Rev05 module does not have a time dimension(year) and your formula seems to be correct. Try adding time dimenstion and give timescale as year. Please refer the below image for your reference.
Hope this helps.
Regards,
Venkatesh
Thank you so much Venkatesh!! :)
I changed the dimension in REV05 to reference G2 Country instead of G3 Location
I also changed the time scale for REV05 to Year But I ended up receiving a different error message
I can't see anything wrong with my modules though
Hi @AnnieMa , This is due to the Dimension you have taken, did you check the dimension in you rev05 module like below mentioned screenshot. If this not works can you share the blueprint view of this module :).
Regards, Venkatesh
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
