- Go to Analysis>Information Library and click Add an Ad-hoc Query.
- Select the Memberships Source View.
- In the left column, click Membership Transaction.
- In the middle column, drag Transaction Date (Date Only) to Include Records Where. Set it To be Between and the time frame necessary.
- Expand membership Transaction in the left column, and click Membership Level Term underneath.
- Drag Term Length from the middle column to Include Records Where and set it equal to 2 Year(s).
Note: The value of the term length must be typed as X year(s) or X month(s), with the (s) included.
- Drag any information you'd like to see into the Results Fields to Display.
