Format of mapping used for lookup doesn't match any dimension of the source

Hi all,

I've looked through several of the queries/answers on this topic and still can't work out what I am doing wrong...

I am trying to provide a summary of employee expenses by region and role in REP04;

I am trying to use EMP02 as my source as this has employee expenses by employee and department. As there is no direct link I was using SYS08 as a lookup link referencing the Employee role and Region (the link being through the common employee details). I get the following;

I'm clearly missing something in the logic - no idea what though...

Thanks in advance!

Emma

Accepted answers

EmmaPF

think I have figured it out - it's not a lookup it's a sum based on certain criteria...

All comments

EmmaPF

think I have figured it out - it's not a lookup it's a sum based on certain criteria...

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…