Macro execution only for highlighted cells

[Former Member]

Dear Macro Experts,

I have a "simple" requirement but I cant find any function in ADVM. Appreciate your tips on easy way of doing it

ROW1: R1Cell1, R1Cell2...R1Cell 5......R1Cell10.... are values in ROW1

Action1: I highlight R1Cell5

Action2: I click on an assigned ugly looking icon to execute this macro

Expected result in ROW2

ROW2: R2Cell1, R2Cell2...R1Cell 5......R2Cell10....are values in ROW2.

PS: I note the same question asked by someone else but the answer was it was not possible in standard. A sample code was also provided but I need to hire an ABAP expert and a week to do that. But that was 3 years ago. I was wishful that there is something available in standard now in newer releases. 

Thanks

BORAT

[Former Member · Accepted solution]

Hi BORAT,

Can you try as below.

Here Base forecast as - ROW1 and Promotional forecast as - ROW2

Before macro execution

selected the bucket - 27.05.2013 and executed the ugly icon 🙂

and the result

Regards,

Nagarjuna

[Former Member · Accepted solution]

ZUPPERRRRRRR

you used COLUMN_MARKED... I saw it and ignored it at first

Full Points has a limit of 10. This ones worth 50

Many Thanks

BORAT

[Former Member · Accepted solution]

Hi Nagarjuna,

A related question...

How do I call a layout variable from ANOTHER data view to perform a calculation ?

e.g. I had this requirement in one of my previous projects but that I left it to rain gods.

What this calculation is supposed to do is this.

Cell Value / Total Value, where TOTAL cannot be known unless I load all CVCs in the data view in which the calculation needs to happen. If I load all the CVCs, then I don't know the cell Value based on which I need to take this ratio and copy to another row in the same data view. So I was wondering if I can call the TOTAL from another data view !

To make example clear

CUST1 - PROD1 - row1, cell1 = 10

CUST2-PROD1- row1, cell1 = 100

CUST3- PROD1-row1, cell1 =50

TOTAL = 160

I now load in shuffler CUST1-PROD1 = 10

I need in row2 corresponding cell r2c1, value = 10/160 = 0.06

How to do this ?

Many Thanks

BORAT