variable in aggr

[#1]

Hi,

I have an expression written in variable overview. I want to use this variable in 'calculated dimension' inside a chart.

For example, variable that I created: vSumOfAll = sum(x)+sum(y)

and I am using vSumOfall inside calculated dimension as :

rank(aggr($(vSumOfAll),[STATE]),4)

This shows an error. Any help on this is highly appreciated.

Regards.

[cesaraccardi · Accepted solution]

Hi

In order to use a calculated dimension you need to wrap-up the expression with an aggr function, try moving the position of the ranking function:

aggr(rank($(vSumOfAll),4),[STATE])

[Aurelien_Martinez]

Hi,

If you do that :

aggr(rank($(vSumOfAll), 4), [STATE])

Aurélien

[#4]

Thank you. It worked though it is difficult for me to understand why it worked this way. I thought rank was decided post aggregation and hence wrote the expression in that fashion. Thanks again..