Hello I need to summarize the excel (attached) here it should be group by year, and group
expected o/p as below. it should sum the values and update it in the each column respectively for year and group . values and year are dynamic which may change every year . last 30 ,60,90 and 120 days should show the month based. as in the year column there is only month and year .
so in last 30 days it should show data of entire previous month ,even if current day is 1st of May it should show all the data of April
and similarly if it is last 60 days it should show last 2 months data and 90 days is last 3 months data
| GROUP | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | Last 30 Days | Last 90 Days | Last120 Days |
| Direct Fund | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) |
| Asset | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) |
| Mutual Fund | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of value |
| Tech Support | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) | Sum of (value ) |
