Just started using EG (and SAS for that matter) and was wondering if it is possible to create two queries on top of a single table, and then create a query using the results of the first two queries.
I have three columns; one for sales territories, one for product and one dollars. I am trying to group the query so I have a percentage mix product calculated for each territory. I was trying to accomplish this by quering up the sums into two queries, then using a join and expression builder to finish off the math.
Is this possible within a single query?
Thanks for help (using EG 4.1)