Organize Date Information

Imagine you want to see your items sold by last three months, current quarter, year-to-date, or year and compare to the previous year. Organize Dates lets you do this over any reference date as follows:

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

2. Select Trending | Organize Dates.

Sample screen shot

3. 3. 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.

   4. Select how you want to calculate the date difference:

      1. For the first date, select between a control panel date (recommended), a date grid column or today's date.

      2. For the second date, select a grid column. Note: the second date will be subtracted from the first date.

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

   6. 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.

   7. Select the date organization you want. All choices that begin with Current do not have a Number value. All other choices let you specify a Number. For instance, if you want the last three months, enter Last Months and 3.

   8. Enter a number in Compare to previous years to compare the defined organization for this year to past years.

   9. Click Ok.