SUM with Group Number

Hi I want to sum Orders with Group Number.

The point is Group Lineitem is not formatted List, is Number Formatted.

 

 1-Nov2-Nov3-Nov4-Nov5-Nov6-Nov・・・
Group123123 
Order100200300400500600 
Odrer(Sum)500700900500700900 

 

I tried Rankcumulate or Sum Functions, But I can't Solve this. 

Answers

  • Hyudolee,

    Can I understand the desire to keep Group number formatted? Is this an imported field?

    I don't see a way around creating a list.
    1. Create Group List with codes the same as the number
    2. Add a line item in this module above and do a FINDITEM('Group List' , Group) so you have a line item list formatted by "Group"
    3. Create another module that sums up the amounts based on the timescale you choose.
    4. Order(Sum) will reference the module created in Step #3.

    Let me know what questions you have.
  • Hi, @sourjyar .

    Thanks for replay.

    I understand your solution.

     

    But in this situation, Group determined  by Time.

    (Like weekday)

    If I want to aggregate Order by Group, I have to make a module(Time & Weekday List).

    We cannot aggregate Time to Group in Anaplan.

     

    It will consume much memories.

     

     

     1-Nov2-Nov3-Nov4-Nov5-Nov6-Nov・・・
    Group123123 
    Order100200300400500600 
    Odrer(Sum)500700900500700900 
  • Let me take a step back and ask a few questions to understand the context better.

    1. How many groups can there be in total? Does Nov 7th start back at 1 again?

    2. When you aggregate your Order (Sum) line item..are you looking at the entire timescale or just one week or just one month? What is the basis of that aggregation?

  • 1. How many groups can there be in total? Does Nov 7th start back at 1 again?

    >> 31Groups( = month) 

       I will use this group as dynamic cycle. It will change by time cycle( month, week)


    2. When you aggregate your Order (Sum) line item..are you looking at the entire timescale or just one week or just one month? What is the basis of that aggregation?

    >> 1months.

     I think we can use day List instead of Time(Day), and save memories.