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.