We could use Rank function to find top 5 Record.
suppose we have Product wise sales below and we want to analysis of top 5 product Sales.then using Bar chart we can easily limit the dimension and achieve. but if we want in Pivot or straight table. it is not easy to find even using limit dimension.
Using rank function we could achive it easily
rank of Sales
and top 5 sales by using
see the ached files for more detail