1. Go to Analysis > Information Library.  Click Add an ad-hoc query.  
  2. Select a source view of Memberships (we will use Memberships since there is no revenue associated with these transactions).  Click OK.
  3. On the left, click Membership Transaction.  In the middle, click Transaction date and move to Include Records Where.  Set the criteria to equal to your time period.
  4. If you only want certain Membership Transactions, in the middle, click Action and move to Include Records Where.  Set the criteria to one of the actions that you would like to see.  For example, One of Join, Renew, Rejoin, Upgrade, Downgrade.
  5. In the middle, click on System Record ID under System Fields and move it to Results Fields to Display.
  6. On the left, click on the plus sign next to Membership Transaction.  Then on the left, click Membership.
  7. In the middle, click membership program and move it to Results Fields to Display.
  8. In the middle, click membership level and move it to Results Fields to Display.
  9. In Results Fields to Display, delete Membership ID so we can get a total count of membership transactions and not a total count by membership.
  10. In Results Fields to Display, click on Membership Transaction\System record id and click the E Sum button.  Mark Count.
  11. Go to Set Save Options tab, name the query and save.
Here is an example of what the query would look like: 
User-added image