top 10 and bottom 10

[paulwalker]

Hi Community,

using straight table I have set Top 10 records in Dimension limits - working fine for top 10 but bottom 10 not working.

is there any issue - I have to show negative values in bottom 10 ?? below is my expression.

NUM(AVG(AGGR((AVG({<GENDER={'M'}>}SALARY)-AVG({<GENDER={'F'}>}SALARY))
/
AVG({<GENDER={'M'}>}SALARY), CO, TITLE, CODE)),'##.#%')

Please find the attachment.

Thanks in Advance!!...

[Chanty4u]

can you try this

NUM(AVG(AGGR((AVG({<GENDER={'M'}>}SALARY)-AVG({<GENDER={'F'}>}SALARY))
/
fabs(AVG({<GENDER={'M'}>}SALARY)), CO, TITLE, CODE)),'##.#%')

or

NUM(AVG(fabs(AGGR((AVG({<GENDER={'M'}>}SALARY))-AVG({<GENDER={'F'}>}SALARY))
/
AVG({<GENDER={'M'}>}SALARY), CO, TITLE, CODE)),'##.#%')

[paulwalker · Accepted solution]

It won't work, value shouldn't be change.

I have managed with below calculation..

IF(RANK(-NUM(AVG(AGGR((AVG({<GENDER={'M'}>}SALARY)-AVG({<GENDER={'F'}>}SALARY))
/
AVG({<GENDER={'M'}>}SALARY), CO, TITLE, CODE)),'##.#%')<=10,

NUM(AVG(AGGR((AVG({<GENDER={'M'}>}SALARY)-AVG({<GENDER={'F'}>}SALARY))
/
AVG({<GENDER={'M'}>}SALARY), CO, TITLE, CODE)),'##.#%'))

-Thanks