Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Team,
Need your help.
I would like to always see sales for the latest 5 quarters, regardless of what year that is filtered on the page.
Thanks,
Alex
Use something like below
Sum( {<Year=,OrderDate={">=$(=AddMonths(Max(OrderDate),-15)) <=$(=Max(OrderDate))"}>} OrderRecordCounter)