Formula

CommunityMember131357

Hi,

 

I have a module created with dimensions rate area, brand and channel. However, I have another module where the user inputs the values only at rate area and department level. So from the module where the user inputs the values we are getting it into the module  with extra dimensions(i.e. brand and channel) thereby causing the values to get repeated on each brand and each channel. So, is there any way to control this so that the values come only at summary level like on each rate area but only at all brands and all channels instead of throwing same value at each brand and each channel.

 

Request your help on the same.

 

Thanks in advance!

Misbah

@CommunityMember131357 

 

Why is your target module dimensioned by Brand and Channel if you don't intend to see values in each brand and channel. In your target module change the dimensionality from Brand to One Level up of Brand dimension and same for channel dimension

 

If you don't want to change the dimensionality then you can split the values equally in the system at each list item level so that you get the same number at summary level.