Addition of several records from different years into one line

[Simon_29]

Hello.

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.


Thank you very much for all the help.

[Greg_Deckler · Accepted solution]

@Simon_29 Seems like you want to right-click your FISCAL_YEAR column and do a Group By?

[Simon_29]

Thank you. It was that: D

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.

well thank you