Views: Get total results

Question

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?

Answer 1

Add a Global: results field to the footer. There is no need to turn on aggregation.