Find my approach below as reference and stored in attached workbook version 9.3 located in the original thread.
1. Recent 12 months:
If datediff('month',[date],today())>=0 and
datediff('month',[date],today())<=11 then [sales] END
2. Previous 12 months:
If datediff('month',[date],today())>=12 and
datediff('month',[date],today())<=23 then [sales] END
comparison_nalmai.twbx 22.7 KB
Thanks for your quick reply. I have some expressions and filters to show the value, so can you explain
how to apply these in worksheet. I asked design part...
follow the below steps to achieve
1) Filter out month and year .... top 24 order date max.
find the attached workbook for reference.
Please don’t forget to mark Helpful and CORRECT if it solves your problem.
Book1 (1).twbx 272.0 KB
Thanks Hundre its working perfectly...