...
2. Defining SUM of Accounts or Account Groups
Option 1 : Formula : Aggregate ( {member,member } )
This example will show you how to aggregate three accounts using the sum method ( "+" symbol). When making the calculated member you have to remember that the "+" symbol will have to be replaced with a "," symbol.
...
You should see the following result.
Option 1 2 : Formula : SUM (member,member )
Option 3 : Formula : member+member+member
Limiting Account group balance by Object
This example will show you how to only return the data of accounts that are connected to a certain object. In this example the values of the 3 Random Accounts created in the previous example will be filtered and aggregated into a single member AUDIO - Accounts. This member will return the account values that are connected to the object AUDIO - Audio Products.
...
You should see the following result:
Info |
---|
You can also include those in Aggregations or SUM. You can limit also by any other dimension existing - dividing by "," . For example : Account 211 , Object Audio , Object Other etc |