rank

In this tutorial, I will show you how you can use Rank function to display top N values in a pivot table.

Objective:

Out of listed fund investments, our objective is to display top 5 Fund investments by the dollar amount.

 Important steps:

1.  Create a calculated dimension to display top N values

2.¬† Make sure that you check “Suppress when value is NULL” for the calculated dimension.

That’s it.

 

photo by: Glenz Tee


If you enjoyed this article, get email updates (it’s free).

Email Address:

Related Posts Plugin for WordPress, Blogger...