Hello
I have a calc module (CALC1) structured around a dummy list 1-20, plus a series of dimensions such as Region (1-3) and Shop Type (A-C), plus a timeline. This dummy list lays out a series of revenue adjustments over time based on the dimension categories, such as [+5% revenue for region 1, shop type c across periods 25-35], [-2% revenue for region 1, shop type B, across periods 47-53], etc.
I also have a list detailing all my shops, and a mapping module (MAP1) that brings in this shop list then has line items formatted as the above region & shop type lists, so that each shop is mapped to a specific region and shop type.
I want to create a calc module (CALC2) structured around the shop list, that adds up all the relevant impacts from CALC1 based on the mapping in MAP1 (i.e. if a shop is Region 1, Type B, sum all the revenue adjustments in CALC1 pertaining to Region 1 and/or Type B)
I've got all the dimensions the same between CALC1 and CALC2 but can't figure out how to bring in the mapping functionality, all my formulas end up bringing in the same total regardless of the shop selected.
Any help would be much appreciated
Many Thanks
