In this entry i will show how to implement a "top n filter" object over our reporting sheet.
First of all , here below we have following chart which contains sum(profit) over region and country for each person.
Now what i want to do is to show Top 2 profits for each person.
Step1
In data panel creating a "Calculated Field" and use following formula.
Step 2
Dragging created object (TOP-N filter) into Filters part.
Step 3
Right click onto TOP-N filter click "edit table calculation" and
choose Compute Using --> Advanced
Step 4
Advance section we gonna select partition and field values in order to define our ranking.
Finally Top-n filter is ready.
Now i am gonna define the range which is top 2 values and Results will be look like this...
Hiç yorum yok:
Yorum Gönder