While on a client site an end user asked me to generate a Count from within Query Studio, and I actually forgot the steps. So my loss is your gain because here are the steps once again:
Note: You do not use the Calculation icon for counts, but instead you should use the Summarize icon.
1. Add three columns to your report.
2. Click Edit Data from the blue menu in the upper left hand corner.
3. Click the Column Title you want to perform the count on.
4. Click Summarize.
5. The Summarize frame will appear under the report, from the Summary for Footers list select Count.
