Top 5 analysis using Rank fuction

    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

    Raw Data:

     

    rank of Sales

     

    and top 5 sales by using

     

     

    see the ached files for more detail