Hey everyone! If I create a view which contains a calculated column, can I later use that column in a group by clause? I'm trying to show invoice amounts by month. I don't really care what date the invoice is created, just the month, so I have a column in the view which grabs (tmon(idate)). I would like to be able to show only one row with the total invoice amount for the month - can I do this?
Thanks so much! Jan Barley
