In Data Model Editor, for a Measure, you can select a 'Custom' aggregation type.
When you do this, the 'Column' property will also need to be changed.
For any of the other standard aggregation types, e.g., 'Sum', the aggregation function will use the selected column in the 'Column' property like this (using the column from the screenshot as an example):
sum(TableName.AmountCM)
Likewise for Avg, Min, Max etc.
But for the Custom aggregation type, you will need to type the full syntax in Column property. In this example, multiplying Budget with 2:
Comments
This is great information. Is there a way we could do that in a virtual cube for a global calculation?
For example, our users are asking for COGS/GS (Cost Of Good Solds / Gross Sales).
The custom calculation would be sum(cube1.COGS)/sum(cube2.GS).
Isn't that just to put [cube1.COGS]/[cube2.GS] in the calculation editor for your Global Calculation...?
We tried that, but then the aggregation is the sum of the ratios, rather than the sum of COGS divided by the sum of Gross Sales...
Please sign in to leave a comment.