Adding Totals

[#1]

Hello.

I was wondering if anyone knows how i can use the set analysis so i can turn and expresion like sum(TOTAL Ammount), to add the total but only of the year of the dimension.

Its something like sum({$<Year={'2013'}>} TOTAL Ammount), but i want to total of each year on the dimension.

pls help,

thanks,

[sunny_talwar · Accepted solution]

This I guess:

=Sum(TOTAL <Year> Ammount)

[#3]

thanks alot

[sunny_talwar]

No problem