Module 1 - No dimensions, just two line items. One of the line items is formatted as List X and the other is formatted as Time Period - Month
Module 2 - I have time and List X as dimensions, and one line item, let's say price.
Now to the problem: What I want to do is to collect the price from the list object selected in module 1 in the line item formatted as List X and present if for another object, in the same list, in the second module.
So for example, let's say I have two list objects in List X, Apple and Oranges. If I, in the first module, select Apples (with a price of 1), I want the second module to display the price of Apple for the list object Oranges.
I tried to do a lookup on the value selected in module 1, but it didn't work...
That's what I did but couldn't get it to work. It is worth mentioning that the price I want to collect is different depending on month. So I actually want to collect the price from a third module, which have time and list X as dimensions.
The formula i tried entering in module 2 was basically module3.price [LOOKUP:module1.list line item], but it didn't work.
Re: Selecting different values over same dimensions
The problem is that it still displays the price of the list item, and kind of ignores the lookup on the selected list item in module 1 if that make sense.
So for example.
List X: Apple & Oranges
Module 1: In the list formatted line item, I have selected Apple
Module 3: Holds prices Apple=1 & Oranges=2
Module 2: List X as dimension. One line item named "Modified price" with the formula: module3.price [LOOKUP: module1.list formated line item] I now want ALL of the list items to display a price of 1, since that is what is selected in module 1. However, it still displays the "original" prices, that is 1 for apple but 2 for oranges. So it kind of ignores the lookup.