Lookup for top level item not working

[TristanS]

I have an aggregates sales forecast module that only has time dimension.

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

当查找与商店的最高标准l 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)

[TristanS · Accepted solution]

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