Sum of value

[dandaanilreddy]

Hello All,

I have categories which has values for each date. I need to sum up the total of category 1 category 2 and category 3 depending on the data range.

For example:

Category 3 has the starting date as 2019-07-09 and has a value 458. Now i want to pick the values from the category 1, 2 , 3 by considering the starting date of category 3. Here i need to pick the values of category 1 and 2 having the date range <= 2019-07-09. Please can someone let me know how to achieve this .

Category 1	Category 2	Category 2	Category 3	Category 3	Category 3	Category 4	Category 4	Category 4
2019-06-28	2019-07-01	2019-07-02	2019-07-09	2019-07-10	2019-07-11	2019-07-16	2019-07-17	2019-07-18
12	14	15	458	871	1284	2523	2936	3349
			Total I need
			499	1370	2654	5136	8072	11421

Thanks