Aggregating

[Biscoluiz]

Hello Guys,

I'd like to sum the total by year not considering the dimension, as you can you bellow:

Year	Color	Value	Total by year
2019	Yellow	14	187
2019	Blue	84	187
2019	Pink	52	187
2019	Black	37	187
2020	Yellow	23	123
2020	Blue	42	123
2020	Pink	23	123
2020	Black	35	123
2021	Yellow	77	233
2021	Blue	41	233
2021	Pink	68	233
2021	Black	47	233

Could you guys help me? 

Sincerly, Luiz

[Don_Stocks_ · Accepted solution]

Sum(Total <Year> Value)