Views: Get total results I am trying to get a total count of the results using Views.  Looking at this link, Count results in Views using aggregation, I use aggregation, but Views counts each row as 1.  For example, this is what I get:

TITLE         Results
"A title"     1
"A title2"    1
"A title3"    1
etc...


I want it to be

Title
"A title"
"A title2"
"A title3"

Results: 3


Any way to do this in Views?  If not, is there a way I can weak the current Views SQL or its output instead of having to write my own module and SQL query from scratch?
Add a Global: Result summary field to the footer. There is no need to turn on aggregation.