If your data contains date information, you may want to see how your data changes by year. To see year trends in your data:

  1. Right-click a column in your grid that you would like to trend.

  2. Select Trending | Year Trend.

Sample screen shot

  1. Select the column you want to rollup for the year trend. Data Access Studio will automatically populate this field with the column you select in step 1.

  2. Select the date column you want to use.

  3. Select the year range you would like to run.

  4. Choose how you want to trend: Sum, Count, etc.

  5. Choose the column you want to use as the ranking quantity. If you selected Count in the previous step, then this field will be hidden.

  6. Click Ok.