How to add a column with yearly total value, ignoring the month dimension in the table

[LanBiteam]

Hello,

I need to create a table like below:

Year	Month	Customer	Sales in the Month	Sales in the Year
2022	Jan.	A	100	300
2022	Feb.	A	100	300
2022	Mar.	A	100	300
2022	Jan.	B	200	350
2022	Feb.	B	150	350

But I don't know how to create the measure "Sales in the Year" in this table. Because of the column "Month" in front. 

Is this possible? Please advise.

Thanks in advance!

Best regards,

Lan

[Michiel_QV_Fan · Accepted solution]

Aggr(NODISTINCT Sum({<Month>}[Sales in the Month]), Customer)

Setting Month in set analysis cancels Month from the selection. the aggr calculates per customer. The nodistinct shows it on each row.

[LanBiteam]

Hey Thanks a lot!