Set Analysis on past year total

[#1]

Dear Community,

I need help on syntax in expression.  I have the total sales with the dimension by year, however, I don't know how to write the syntax which the total amount of current year divides by last year total sales of sum of 2 products.  

See whether anyone could help, I really appreciate on this. 

Thanks.

[Gysbert_Wassenaar]

If you're using year as a dimension then set analysis won't work. Try using the above() function or an AsOf table. See this document: Calculating rolling n-period totals, averages or other aggregations

[#3]

Hi,

PFA ,

Hope it helps you