Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Attached a possible solution.
I want the user to select number of rows based on the rank.
The user can introduce the number of rows in the following object available in the dashboard (screenshoot attached)