Re: Calculating last 6 months based on selected month
You need to ensure that the month field contains date values (formatted as months), or that you include a month sequence field. In either case, you can use simple date calculations in the set expression to produce the result. You will also need to mask the date selection.
For example, define a month sequence in the load:
Year(trans_date) as Year,
Month(trans_date) as Month,
(Year(trans_date)-2000)*12 + Month(trans_date) as MonthSequence,