Button to select top "N" values based on the user selection?

[poluvidyasagar]

Hi,

I am trying to create the button that helps the user to select top "N" values based on his choice.

Here is the data below:

My dimension in the following pivot table are:

1. Part Number

2. Inventory Balance

3. Actual Balance

Measures:

Difference = (Actual Balance - Inventory Balance)

Rank  =Rank( TOTAL([Actual Balance]-[Inventory Balance]),1,4)

Can someone advise me on this?

Part Number	Inventory Balance	Actual Balance	Difference	Rank
C2	34592	120000	85408	1
A1	8487	21940	13453	2
A2	1054	7579	6525	3
B8	256	2048	1792	4
C1	1305	1932	627	5
B3	833	1380	547	6
A3	495	1017	522	7
B2	60	395	335	8
D5	660	856	196	9
B1	1045	1208	163	10
E4	571	660	89	11
D10	655	729	74	12
E2	0	47	47	13
D3	0	44	44	14
A4	173	208	35	15
A8	21	52	31	16
D9	54	70	16	17
D8	44	55	11	18
E11	0	9	9	19
A5	0	1	1	20

Thanks,
Vidya    

[jaumecf23]

Hi,

Attached a possible solution.

[poluvidyasagar]

I want the user to select number of rows based on the rank.

[jaumecf23]

The user can introduce the number of rows in the following object available in the dashboard (screenshoot attached)