Level Mismatch on Common Dimension
I have a data entry module with 3 lists: versions, row id, and line item list. I have 3 line items: person, cost center, country, with type of List and link to person (L3), cost center (L2), country (L1) lists. The input is to select person, then cost center and country is derived from the hieararchy.
The second module has 4 lists: versions, row id, cost center, and line item list. One of line items is currency. I want to get the respective currency of the cost center by looking up from country (L1) list which has local currency property.
So I use function like this: 'Country L1'.Local Currency[LOOKUP: FirstModule.Country ]
However, I got error: Level Mistmatch on Common Dimension