SUM with Group Number

hyudolee

Hi I want to sum Orders with Group Number.

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

 

	1-Nov	2-Nov	3-Nov	4-Nov	5-Nov	6-Nov	・・・
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. 

sourjyar

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.

hyudolee

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

sourjyar

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?

hyudolee

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.