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?