Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Say you have a straight table containg multiple rows (using one dimension) and just one column (one expression). The formula used to arrive at the individual row values is complex [uses divisions, multiplications, set analysis]. The total of the column however is merely the sum of the rows and hence I'm setting the Total mode to "Sum of rows". Now I want this total (which appears in the top most row, above the first row) to be stored in a variable for use in other computations. How do I achieve this?
Help much appreciated.
Regards,
Gopal
You should be able to use advanced aggregation in your variable definition to achieve what you want:
In variable overview, use this expression as definition:
=sum( aggr( YourComplexExpressionFromTheTable, YourDimensionFromTheTable))
You might run into some issues if you are using chart inter record functions in your complex expression, like above(), but you haven't listed that
You should be able to use advanced aggregation in your variable definition to achieve what you want:
In variable overview, use this expression as definition:
=sum( aggr( YourComplexExpressionFromTheTable, YourDimensionFromTheTable))
You might run into some issues if you are using chart inter record functions in your complex expression, like above(), but you haven't listed that
Piece of cake! Thanks swuehl.
This was exactly what I was looking for. Thank you very much.
Hi, It'd be great if you could suggest what to do if i'm using above() in my expression? TIA