Aggregating sales amount based on filter criteria

satyampatil
Occasional Contributor

Aggregating sales amount based on filter criteria

 

We have 3 modules where:

 

1. The Allocation module has Unique IDs(UID1), Time as a dimension and Attributes as Line items

 

satyampatil_1-1635530539782.jpeg

 

2. The Sales Data has Unique IDs(UID2) as a dimension, Time, Attributes as Line items

satyampatil_2-1635530539786.jpeg

 

3. Output Module which has UID1, UID2, Time as a dimension and Attributes as Line items

Screenshot (13).png

 

We have to allocate the amount in the allocation module into the sales module based on the sales quantity ratio in the sales module corresponding to the filter or joining criteria.

We have to aggregate the sales quantity amount based on the filter / join criteria mentioned above(AGG KEY = Company Code, Division, Sales Organization, Sales Office, Profit Component, District, IndustrySubSegment, ProductHierarchy).

 

Division, SalesOrg, CompanyCode, ProfitCenter -> should be an exact match in both of the modules (1 & 2) IndustrySubSegment, SalesOffice, District, ProductHierarchy, Material -> if a value is present in the allocation module then should be an exact match in the Sales module, else if this is missing in allocation module then consider all values for these attributes in the sales module

 

In the output module, we can't add other attributes as dimensions Since those are lists with millions of data.

1 REPLY 1
einas.ibrahim
Master Anaplanner/Community Boss

Hello @satyampatil 

It seems to me you can use the SUM function

Have you actually tried it?

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"

Dear community members
Consider posting your question as a new topic and not in the thread of another topic/question. This help other community members to easily find the answer they looking for and doesn't cause the original thread to be so cluttered that we can't find what we are looking for