Calculated Dimension

[upaliwije]

Hi Friends,

I have created a calculated Dimension with following command in my pivot table

=If(Aggr(Rank(Sum({<VEHICLE_TYPE={'CAR/JEEP'}>}CLMPCNT)/sUM({<VEHICLE_TYPE={'CAR/JEEP'}>}POLNos))>5, [MAKE])<=10, [MAKE], 'Others')

But It does no work properly.

My requirement is to Show 10 records of Vehicle Make where the value of the  following condition is more than 5

Sum({<VEHICLE_TYPE={'CAR/JEEP'}>}CLMPCNT)/sUM({<VEHICLE_TYPE={'CAR/JEEP'}>}POLNos))>5

Kindly help me to get the correct syntax please.

[Brett_Bleess]

Just kicking this back up in the list with a comment to see if Sunny or someone else has any other ideas on things.

Regards,
Brett