I'm not sure I fully understand the requirements but I can show you how to grab values like you're describing.
In my example, I took the average of the 4 quarters of the previous year to use as a value in the current quarter.
You could use that value to compute whether that quarter was above or below the average of the previous year's quarter.
window_avg(sum([Sales]),-1*(attr(datepart('quarter',[Order Date]))+3),-1*attr(datepart('quarter',[Order Date])))
Let me know if this helps get you started to what you're looking for
This is perfect. Exactly what I need. The only thing I change is exclude unwanted periods and chart quota vs. actuals rather than using tabular table.
Thanks again for the very promt assistance on this.
Excellent, glad to help.
If you question is no longer pending, please set to answered so that we can keep the forum clean.