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.
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 .