calculate values from modules with different dimensions but with same ancestor list

jo_maassen_1
Occasional Contributor

calculate values from modules with different dimensions but with same ancestor list

Hi,

 

This is my first post so I hope the example will be clear.

 

I have a ‘Customer Hierarchy’ list and a ‘Product hierarchy’ list.

Both lists have the same parent hierarchies (see print screen 1 below)

jo_maassen_1_1-1617268728602.png

 

Now I have a Sales module with the customer hierarchy as dimension and 2 line items (sales volume, product)

The product line item is formatted as list products (see printscreen)

jo_maassen_1_2-1617268816079.png

 

I would like to create a new module with products as a dimension.

This module should calculate the sales volumes per material (retrieved from the Sales Module).

It should look like:

jo_maassen_1_3-1617268902211.png

 

 

However I did not  manage to do this due to the different dimension issues and the 2 list having the same ancestor.

Could anyone help me how I could solve this?

I added print screens with the existing modules (simplified) and desired module.

 

Thanks in advance for your help

Jo

1 ACCEPTED SOLUTION

Accepted Solutions
abhi1017
Super Contributor

Re: calculate values from modules with different dimensions but with same ancestor list

Hi @jo_maassen_1 

 

Dimensions of the modules are different but you do have a list formatted lineitem of products in customer hierarchy dimensioned module.

Use the List formatted product lineitem to SUM and you will have the required data in the product dimensioned module.

Formula for product hierarchy module shall be something like :-

Lineitem SalesVolume[SUM:Lineitem product] (Have used same naming conventions as depicted in screenshots)

 

~ABhi

 

View solution in original post

2 REPLIES 2
abhi1017
Super Contributor

Re: calculate values from modules with different dimensions but with same ancestor list

Hi @jo_maassen_1 

 

Dimensions of the modules are different but you do have a list formatted lineitem of products in customer hierarchy dimensioned module.

Use the List formatted product lineitem to SUM and you will have the required data in the product dimensioned module.

Formula for product hierarchy module shall be something like :-

Lineitem SalesVolume[SUM:Lineitem product] (Have used same naming conventions as depicted in screenshots)

 

~ABhi

 

View solution in original post

jo_maassen_1
Occasional Contributor

Re: calculate values from modules with different dimensions but with same ancestor list

Thank you very much for your super fast respons! 

Sometimes it can be so easy 🙂