How to sum time ranges

hyudolee

I have a problem when aggregating lineitem by time .

 

I want to aggregate Amount by "Aggregate Lineitem" (From Jan-21 To Mar-21).

The Module A&B has set by time range, so we can't do it.

 

Table A ( Time Range : past 2years)

List	Month	Jan-21	Feb-21	Mar-21	Apr-21	May-21
Lineitem	Amount A	100	200	300	400	500
	Aggregate	✔	✔	✔
	Amount B	100	200	300	0	0

 

Table B (No Applies To) 

List	None
Lineitem	Amount	600

 

 

Please give me a solution.

Misbah

@hyudolee 

 

Use TIMESUM function.

 

 

Misbah