Hello,
Requirement: 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 a 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 | |
| 1 | |
| 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.