Aggregate from a source module to a module with common but less dimensions

Hello,

I somehow struggle to find an answer to this problem:

I have my line item "Sales" in Module 1, which is formatted with Dimensions A, B, C, D and Time (Year) and I want to aggregate these sales in the line item "Aggregated Sales" in Module 2 which is formatted with Dimensions A and B only (no time format).

Could somehow guide me on how to get it to work ?

Thanks a lot !

Accepted answers

BrunoRodriguez

Hello @QZ ,

If all the dimensions have top level, you should only make a [SELECT:TIME.All Periods] or a lookup for whatever summary you want.

Cheers!

Venki9902

Hi @QZ ,

As per the above discussion if you have top level for the dimension A,B,C,D for module1(Time dimension) then in module2 which has A,B without time dimension then in the "Aggregated Sales" line item you can give timesum(module1.Sales).
Then you will get the expected data.

Attaching screenshot for your reference.

Hope this helps :)

Regards,

Venkatesh

HimanshuRaj

Hi @QZ

You can use Timesum formula of Anaplan in your target module and that'll giev you the result you need

Cheers!!

All comments

BrunoRodriguez

Hello @QZ ,

If all the dimensions have top level, you should only make a [SELECT:TIME.All Periods] or a lookup for whatever summary you want.

Cheers!

Hello Bruno,

Thanks for the suggestion. It seems that when I use [SELECT:TIME.All Periods] it sums at the top level for everything else, discarding my dimensions A and B (the common ones, from which I do not want aggregation)/

Do you have a suggestion for me to fix this ?

Thanks a lot

BrunoRodriguez

Hello @QZ ,

You could try to stop the data before it hits the module dimensioned by all the A, B, C, D. However, the extra dimensions are only slicing the data in a different way. I suspect that the top level for A,B,C,D or A,B should be the same, shouldn't it?

Cheers!

Venki9902

Hi @QZ ,

Attaching screenshot for your reference.

Hope this helps :)

Regards,

Venkatesh

HimanshuRaj

Hi @QZ

You can use Timesum formula of Anaplan in your target module and that'll giev you the result you need

Cheers!!

Hello everyone,

Thanks for all the suggestions !

I managed to get Bruno's solution to work since I discovered an issue in another calculation that prevented it to work, but it was actually correct.

Tried the TIMESUM as well just now after reading your comments and that yields the same result, good discovery ! I'll remember it for other calculations too.

Problem solved after all, thanks again !

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385