This may seem simple but I am still quite new and have to learn how to translate our out-dated practices (Fox Pro and Excel 4.0) to SQL.
I need to produce an aggregate or total item from a query. The underlying data does not contain an aggregate or total version of the data involved. Below is an example that should illuminate this.
The resulting report would look like this.
Looks like Area is a constant value in your results so I have hardcoded that in my example below, give this a try:
answered Nov 30, 2017 at 11:12 PM