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.
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.