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?