Addition of several records from different years into one line
I would need to make such an output from this table that I only have 2019, 2020 and once 2021 left in the FYSCAL_YEAR column, and that the SUM column will make the sum for those years from all the records. Thus, in total there will be only 3 rows and at the end of them will be the sum of all values from the SUM column for the year 2019, 2020, 2021. I'm sending a screenshot of what my spreadsheet looks like.
Can I Make Several Group By In One Query? That could be done, for example, Group By based on FYSCAL_YEAR, but also, for example, PRODUCT_NAME or PLATFORM. Similar to the Pivot Table, where there are several criteria.