Hallo out there... looking for at solution in BEx variables to support the following scenario:
In my Bex Query I have in the rows the characteristic 0CUSTOMER. In the columns I have the keyfigure "Turnover" pr 0CALMONTH ( = very basic setup!) On 0CUSTOMER I have an attribute "FOKUSMTH" which provides the info that on this month special sales focus was given to this customer.
I would like to be able to generate two restricted KF on "Turnover":
KF1: Where the months I consider are restricted to the periode before the "FOKUSMTH"
KF2: Where the months I consider are restricted to the periode after the "FOKUSMTH"
So I need a BEX variable that for each customer (= for each line in the report) returs the attribute "FOKUSMTH" from the customer on that line so that I can use this value to restrict on 0CALMONTH.
Please advice...
Regards Peter Starup