Dashboard filter-current year minus 1

Here is how I have done something similar:

  1. Create a calculated field in the BAQ that is simply a flag… possible answers are “ThisYear”, “LastYear”, and “BeforeLastYear”. This calculation can be done very easily using the BAQ.
  2. on the Dashboard, you can HIDE this field, but using the TABS, you can still filter the data into three different tabs.
2 Likes