I have to create a dashboard which works as follows
1. There is a matrix of Sales Reps - Product IDs and their pricing recommendations
| Sales Rep | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 |
| SR1 | $12.00 | $15.75 | $22.00 | $32.50 | $45.00 | $11.50 | $17.00 | $23.75 | $30.25 | $41.50 | $9.75 |
| SR2 | $10.00 | $15.00 | $23.50 | $31.75 | $46.50 | $10.75 | $16.75 | $22.50 | $31.25 | $40.25 | $10.50 |
| SR3 | $9.50 | $16.50 | $21.75 | $32.00 | $46.75 | $12.25 | $18.00 | $23.00 | $32.00 | $42.25 | $12.50 |
| SR4 | $11.75 | $14.50 | $23.25 | $30.50 | $47.00 | $12.00 | $18.50 | $24.00 | $29.75 | $42.50 | $13.00 |
| SR5 | $12.25 | $15.25 | $24.00 | $30.00 | $47.25 | $11.75 | $17.25 | $24.50 | $31.50 | $43.00 | $13.25 |
| SR6 | $10.50 | $17.00 | $22.50 | $31.50 | $46.00 | $10.50 | $16.50 | $22.75 | $32.50 | $41.75 | $11.00 |
| SR7 | $10.75 | $14.75 | $22.75 | $33.00 | $46.50 | $11.00 | $15.75 | $23.25 | $30.50 | $40.50 | $10.75 |
| SR8 | $12.50 | $16.25 | $21.50 | $33.50 | $44.75 | $10.25 | $17.50 | $24.25 | $31.00 | $43.25 | $11.50 |
| SR9 | $9.00 | $16.75 | $24.50 | $31.25 | $44.50 | $11.25 | $16.25 | $23.50 | $30.75 | $42.00 | $10.75 |
| SR10 | $11.25 | $15.50 | $23.00 | $30.25 | $45.50 | $12.75 | $16.00 | $24.75 | $32.25 | $40.75 | $12.50 |
2. I want the dashboars to be SR specific. e.g. user SR2 should be able to see only his price recommendations and no one else's. I can d that using dynamic RLS
3. If SR2 is the user the he/she should be able to accept/reject the prices. If he/she rejects, he should be able to enter a new price which he/she thinks is correct which is stored at back end.
How to implement the last part is where i am struggling. e.g. I want the user to be ablee to see "Accpt/Reject" button/slicer below each and then enter a price in a text box below which is connected to a database/spreadsheet |
