Further help, with what should be a simple lookup

DeveloperCYT

Hi,

I have a ranking module as below

This shows the top customers and some data changes ranked, also there is an image for each customer

Now I have a module where I need to store the top 5 customers images to feed a business report

A simple lookup in Excel, looking up 1 ,2,3,4,5 etc but for the life of me i can't figure this out.

Thanks

Accepted answers

pyrypeura

Hi @DeveloperCYT ,

If you have 1 to 5 module dimensionalised by list that has items Image 1, Image 2... I would recommend adding codes for those items. The codes would be 1, 2, 3, 4 and 5.

Then you could create a line item called 'FINDITEM Image' in ranking module. Formula for that module would be FINDITEM(Image List, TEXT(Min Rank) . Lastly you can in the 1 to 5 module get images for top customers with formula 'Ranking Module'.Image[FIRSTNONBLANK: 'Ranking Module'.'FINDITEM Image']

Hope this explanation helps.

Best regards,

Pyry Peura

All comments

Misbah

@DeveloperCYT

You need to share the dimensionality of your target module.

JaredDolich

@DeveloperCYT

Hopefully, your image is in a system module. If that's the case, I would recommend a simple LOOKUP function. You also need to make sure your image line item is formatted as TEXT (link).

ryan_kohn

Why do you need a separate module at all? Seems like you can just use a filter to filter your original module where Rank <= 5.

pyrypeura

Hi @DeveloperCYT ,

If you have 1 to 5 module dimensionalised by list that has items Image 1, Image 2... I would recommend adding codes for those items. The codes would be 1, 2, 3, 4 and 5.

Hope this explanation helps.

Best regards,

Pyry Peura

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…