Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
PFA ,
Hope it helps you