If you are unable to create a new account, please email support@bspsoftware.com

Author Topic: Query Studio Count Function  (Read 9526 times)


  • Guest
Query Studio Count Function
« on: 07 Nov 2008 02:37:09 pm »
When I summarize a field and select "Count", I end up with a total in the footer. I want to replace the detail with 1 record, the count. In Report Studio I would simply change the query item to Count(field).
We want to be able to have quick & dirty reports for our QS users to be able to work with.
Any thoughts?,


  • Guest
Re: Query Studio Count Function
« Reply #1 on: 10 Dec 2008 12:40:17 am »
Hi There,

There's definitely a way to do it:
1. In query studio, go to 'Edit Data'. 
2. Click the data item you wish to count (eg. customerID)
3. In the 'Edit Data' menu, click 'Summarize...'
4. In the 'Summarize' pane that appears on the bottom of the screen, on the top right there is an 'Advanced' hyperlink.  Click it.
5. Choose 'Summary for Cells' = Count (or Count Distinct)
6. Choose an appropriate (or none) summary for footers
7. Click OK


Hope this helps.