Author Topic: Summarize a single column  (Read 953 times)

Offline ry1633

  • Statesman
  • ******
  • Join Date: Apr 2015
  • Posts: 278
  • Forum Citizenship: +0/-1
Summarize a single column
« on: 13 Aug 2015 12:32:27 pm »
In Query Studio, how do I summarize only a single column?  In a simple report I'm setting up I have [ESTABLISHMENT_ID] and [ESTABLISHMENT_CODE] and I only want to Summarize the [ESTABLISHMENT_CODE] field.

But when I click the column header for the CODE field and then click the Summarize tool, it summarizes both fields in the footer which is what I don't want.

Offline TziRi

  • Associate
  • **
  • Join Date: Aug 2015
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: Summarize a single column
« Reply #1 on: 27 Aug 2015 08:07:40 am »
I tried it and for me works fine,but you need first to delete the group by ,then you select the column and use the sum tool and after you can group by the column you want. If you have 2 columns and you group by the first one and then you click on sum tool,it will show you after every row a new row that has the id you grouped by and the total of the id. I think this is your problem,if you had 3 or more columns and didn't group before the sum, you would have seen that it doesn't make a total for all the columns.