Total function

[BI_Dev]

ID	Year	EXP	New Exp
123	2022	$ 100,000	$ 100,000
123	2023	$ 0	$ 100,000
123	2024	$ 0	$ 100,000
123	2025	$ 0	$ 100,000
456	2015	$ 200,000	$ 200,000
456	2016	$ 0	$ 200,000
456	2017	$ 0	$ 200,000
456	2018	$ 0	$ 200,000
456	2019	$ 0	$ 200,000
456	2020	$ 0	$ 200,000

Hi - I have the above data...want to create new column 'New Exp' as above, where same Expense amount is diaplyed for all years per lease.How can I do that ?

Thank you much.

[BI_Dev · Accepted solution]

Resolved this usimg below expression

=Aggr(Sum(TOTAL <[D]> [Exp]), [ID], Year)