Skip to Content
0
Former Member
Nov 05, 2014 at 04:46 PM

Year to date for previous years

17 Views

Hi all,
I have cross-tab report for vendors and their annual totals. Since, we are not at the end of 2014, I would like to adjust previous years to the same date interval to compare apples to apples.

How can I do this with data selection right now in the selection formula it is:

Date is between 01/01/12 and 11/4/14. What I want to do is

Dates are 01/01/12 - 11/4/12 and 01/01/13 - 11/4/13 and 01/01/14 - 11/4/14.

Is this possible?

Attachments

Capture.JPG (26.7 kB)