Lookup for top level item not working

TristanS
Frequent Contributor

Lookup for top level item not working

I have an aggregates sales forecast module that only has time dimension. chilled0ut_0-1634623040144.png

The sales line item in the aggregation module is doing a lookup at sales metrics module that has stores and scenarios as a dimension. 

chilled0ut_1-1634623128727.png

 When the lookup against the stores is the top level item "All Stores" it returns 0. But in sales_metrics screenshot it definitely has data. But when I change the lookup from "All Stores" to just one of the stores in the aggregation module then it works (ignore the fact that the value for the one store below is same as All Stores ... it's just test data)

chilled0ut_2-1634624121333.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
TristanS
Frequent Contributor

All good found the answer to my own question. I need to replace the Lookup with a select on the top level item 

Select: Stores.All Stores

View solution in original post

1 REPLY 1
TristanS
Frequent Contributor

All good found the answer to my own question. I need to replace the Lookup with a select on the top level item 

Select: Stores.All Stores