TOTAL means the expression (Sum, Min) etc. is applied across all the records available to the chart, rather than just those matching the dimensions on this row. If you include a field in the <...>, then it will create a subtotal for each unique combination of those fields.
AGGR on the other hand creates a mini-chart based on the expr and dimension. The mini-chart will have one expression (the one defined within the Aggr function) and one or more dimensions based on the fields listed.
Example data may be
CustProd TransDate Price
123 1/1/11 100
123 2/1/11 110
123 3/1/11 110
Working from the inside,
Min(TOTAL <CustProd> TransDate). Fairly easy. This generates a list of CustProd records and the lowest TransDate for each. If this was an expression it would return the first transdate for each Customer / Product. Useful, but we want the price, not the date.
Next step, is to get the Price for the first date.
This will return the Price is the TransDate is the first date for this CustProd record. Problem is that in the chart, we list all dates, so this only shows the Price on the first record. We want to see the first price on all records.
To do this, need to apply the first Sum(TOTAL <CustProd> so that it all records for a CustProd can access the first price. But can't do this without putting in an AGGR function b/w the Sum and the Min.
The AGGR(If(TransDate = Min(TOTAL <CustProd> TransDate),Price),CustProd,TransDate) creates a mini-chart that looks like this:
CustProd TransDate Price
123 1/1/11 100
Only the first date is returned as all other dates fail the If(TransDate = Min...) test and so return Null (which is ignored).
What's important is that every record for this CustProd will create the same chart - if it has access to all records of that CustProd - which it does as the first Sum function has TOTAL <CustProd> in it.
The final Sum(TOTAL <CustProd> .... ) simply sums the Price from that MiniChart and works out the first price is always 100.
TOTAL means the expression (Sum, Min) etc. is applied across all the records available to the chart, rather than just those matching the dimensions on this row. If you include a field in the <...>, then it will create a subtotal for each unique combination of those fields.
AGGR on the other hand creates a mini-chart based on the expr and dimension. The mini-chart will have one expression (the one defined within the Aggr function) and one or more dimensions based on the fields listed.
Example data may be
CustProd TransDate Price
123 1/1/11 100
123 2/1/11 110
123 3/1/11 110
Working from the inside,
Min(TOTAL <CustProd> TransDate). Fairly easy. This generates a list of CustProd records and the lowest TransDate for each. If this was an expression it would return the first transdate for each Customer / Product. Useful, but we want the price, not the date.
Next step, is to get the Price for the first date.
This will return the Price is the TransDate is the first date for this CustProd record. Problem is that in the chart, we list all dates, so this only shows the Price on the first record. We want to see the first price on all records.
To do this, need to apply the first Sum(TOTAL <CustProd> so that it all records for a CustProd can access the first price. But can't do this without putting in an AGGR function b/w the Sum and the Min.
The AGGR(If(TransDate = Min(TOTAL <CustProd> TransDate),Price),CustProd,TransDate) creates a mini-chart that looks like this:
CustProd TransDate Price
123 1/1/11 100
Only the first date is returned as all other dates fail the If(TransDate = Min...) test and so return Null (which is ignored).
What's important is that every record for this CustProd will create the same chart - if it has access to all records of that CustProd - which it does as the first Sum function has TOTAL <CustProd> in it.
The final Sum(TOTAL <CustProd> .... ) simply sums the Price from that MiniChart and works out the first price is always 100.
