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 . year mentioned in the excel is year and month as there is no date available . also need to calculate last 30 days ,90 and 120 days even if the there is no data it is fine
| 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 ) |
| | | | | | | | | | | | | | |
| | | | | | | | | | | | | | |
