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
