1. Go to Analysis>Information Library and click Add an Ad-hoc Query.
  2. Select the Memberships Source View.
  3. In the left column, click Membership Transaction.
  4. In the middle column, drag Transaction Date (Date Only) to Include Records Where. Set it To be Between and the time frame necessary.
  5. Expand membership Transaction in the left column, and click Membership Level Term underneath.
  6. 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.
  1. Drag any information you'd like to see into the Results Fields to Display.