Lookup for top level item not working

Options
TristanS
TristanS
in Modeling

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

 

 

Tagged:

Best Answer

  • TristanS
    TristanS
    Answer ✓
    Options

    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

Categories