Begin your query:
  1. Navigate to Analysis, then click on Information library
  2. Click Add an ad-hoc query
  3. Select Source view of Revenue and click OK

Add fields to Include records where:
  1. From the middle column, drag Date into Include records where. Set to equal to your date range.
  2. From the middle column, drag Payment method into Include records where. Set equal to Credit Card.

Add fields to Results fields to display:
  1. The Amount and Date will automatically display in your Results fields to display.
  2. To also see Revenue ID: In the left column, select Revenue. From the middle, drag Revenue ID into Results fields to display.