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.
1Nov  2Nov  3Nov  4Nov  5Nov  6Nov  ・・・  
Group  1  2  3  1  2  3  
Order  100  200  300  400  500  600  
Odrer(Sum)  500  700  900  500  700  900 
I tried Rankcumulate or Sum Functions, But I can't Solve this.
Comments

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.0 
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.
1Nov 2Nov 3Nov 4Nov 5Nov 6Nov ・・・ Group 1 2 3 1 2 3 Order 100 200 300 400 500 600 Odrer(Sum) 500 700 900 500 700 900 0 
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?0 
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.
0