Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Hey Thanks a lot!