Get code nex to list item in module dimensioned by time

Hi,

I have the following module:

Lists: E1 Employee

Time: Month

Versions: -

Line Item: Salary

I need a pivot with the employees as rows and month by column. All fine uptil now. But then I would like the employee code to show up next to the employee list item name. What would be the best way to go about that? If I add another line item "Code" then I don't get the result I'm after... and I don't wanna have to create a new list replicating employee code and adding that dimension as that would **** up the module.

Best regards,

Johan

Accepted answers

JaredDolich

@johan.marketoft

I can't think of a way to achieve that cleanly. The only pure way I can think of is that you concatenate the code and name as the list item. A slightly less intuitive way would be to add another grid from you employee system module that after you click on an employee that has your time dimension in it, the grid synchronizes the details of that employee and shows you the code. Sorry, not the answer you were probably hoping for.

All comments

JaredDolich

@johan.marketoft

CommunityMember126793

Hi @johan.marketoft

Are u looking to achieve something like this?

	Code	Jan	Feb	Mar	Apr	May
A	1
B	2
C	3

Such case, your list E1Employee can have "Emp Code - Emp Name" concatenated and you can keep the dimensions as it is in the module.

Result would be like:

	Jan	Feb	Mar	Apr	May
1 - A
2 - B
3 - C

I don't know if the response met your expectation..

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…