I am calculating previous month date(AddMonths(date#(max([Months Number]),'YYYYMM'),-1),'YYYYMM') by using this formula for calculating previous month sales.
But when I am choosing any Rep id then the previous month calculation is going changed as per the rep id selection.
How to keep it fixed? Means I want the previous month is always max(month number)-1 irrespective of any selection.