Rank() Vs Dimension limits

[#1]

HI,

Could pls explain about these rank() and Dimension limits

For Eg: if we need top 5 we can use dimension limits instead of Rank function (but in pivot table dimension limits not available).

Is there any special use of rank function other than this??

Pls share your ideas....

[#2]

Hi Sarathy,

Based on scenarios, either dimensional limits or rank can be used to achieve the desired result. Recent post where rank function is used to achieve the top N limit is Show only the 10 largest ABSOLUET values

For straight forward scenarios you can make use of Dimensional Limits.

Thanks,

Sri