top 10 positive and negative values set expression?

[daisy1438]

Hi

I am using the below expression for calculating budget value.it having some positive and negative values.

Sum({<[Budget Type Code]={'Budget'}>}Expense)

now i need to find out the top 10 positives budget and top10 negative budget.

what is the set expression for this requirement?

thanks 

[Channa]

=aggr(if(rank(sum(CUSTOMS_VALUE_QAR))<=10 or rank(-sum(CUSTOMS_VALUE_QAR))<=10,COUNTRY_NAME_EN),COUNTRY_NAME_EN)

this is top 10 and bottom 10

[pradosh_thakur]

What is your dimension ? You want to see top 10 positive and negative budget for what exactly ? An example would help

@Channa  how did you figure out the field ? Unless i am missing something.

[Channa]

=IF(aggr(rank(sum(CUSTOMS_VALUE_QAR))<=10,COUNTRY_NAME_EN)=-1,'Top','Bottom')

this will do add new column

[pradosh_thakur]

@Channa  my question to you was not about the expression. I was asking  about CUSTOMS_VALUE_QAR  and COUNTRY_NAME_EN column . How did you find this column ? he has not mentioned it in the question.

[Channa]

expression should be dimension bro,

measure just add SUM(customs_value_qar)

[pradosh_thakur]

I guess you didn't understand my question. I was not asking you the answer, I was asking how did you know the field he has used ? He has not mentioned the field you have used anywhere in the question. 

Anyways that's fine.