Quote:
Originally Posted by sarettah
Select title, sum(amount) to total_amount from tablename group by title
.
|
Awesome, thanks
Now another question I have is, can I include that in a drop down menu to select a range of different options? For example, Title, Author, Sales Channel, etc, etc?
I'm trying to minimize the amount of navigation required so just being able to throw together 1 page and have a drop down to change reports would be a perfect solution, if its not too involved lol