Dear SAC Experts,
We need to retrieve the corresponding Dimension value from the row and Period value from the column whenever a cell value is changed.
For example, in the screenshot, if a user enters 10 in a cell, I need to capture the Dimension value "PQR" from the row and the Period value "202602" from the column using the script.
Could someone please help me with the scripting approach to achieve this?
Request clarification before answering.
| User | Count |
|---|---|
| 10 | |
| 5 | |
| 5 | |
| 5 | |
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.