Find my approach as reference below and stored in attached workbook version 9.3
A. Offset: DATEDIFF('month',[Order Date (Exact)],[Order Date (Exact) Parameter])
B. For each Month: if [Offset]>=X and [Offset]<=X+11 then [Sales] END
C. Top X based on CM
D. Sub-Category sort on
dynamic sort trend 2.twbx 1.2 MB
Thanks so much for your reply. this solution gets close. However, I need the x axis to represent the month of the preceding 12 month period.