Sum from one numbered list module to another numbered list module

CommunityMember120559

I have imported my transactional data as a flat table using a numbered list. Something like this:

 

I want the user to go into a second module where they can select drop-downs for City, and it will sum the sales. This second mapping module must be a flat table too (numbered list) because if I were to dimensionalize it, the model would explode (my real data has many more attributes than just City).

 

How can I SUM the Sales into the second module? I get an error when using SUM, because there are no list dimensions in the 2nd table except for the numbered list of Mapping.

rob_marshall

@CommunityMember120559 ,

 

You will have to make a line item in the transactional module a list formatted line item, whether that is what you currently have as City or a new one (preferably, your current line item of City should be formatted as a list).  In the 2nd module, you will need to have it dimensionalized by the City list so the sum will work.

 

You stated this will **** up your model because you have more attributes.  What are all of the attributes?  Do some of them relate to each other like a hierarchy?  For example, if you have city, state, and country, you could create a hierarchy for of just that (city rolling up to state rolling up to country), but the module to pull the Sales data in would just come from city so state and country would automatically aggregate.

 

Hope this helps,

Rob