How to show customers which have sales only in current year

[former_member374954]

Hi Guys,

My user wants to see only those customer who have revenue for the current year only in BEX.

How can I achieve that?

Regards

Prashant

[ccc_ccc · Accepted solution]

Hi Prashant,

Create selection like below

1. Right lick on columns select "New selection"
2. Drag "Revenue" key figure
3. Drag Current Year SAP Exit for 0CALYEAR.

Thank you,

Nanda

[former_member374954 · Accepted solution]

It will bring every customer who bought from us this year...it will not filter those who bought last year too.

Basically user wants to know who are the new customers?

[Loed · Accepted solution]

Hi Prashant,

Let's call your SINGLE input variable as ZYEAR..

1. Create two (2) RKFs..

RKF1:

Revenue KF

Calyear  restrict with variable ZYEAR

RKF2:

Revenue KF

Calyear restrict with variable ZYEAR (EXCLUDE - tick the red square)

2. You may do either of these:

2.a) Create a FORMULA and enter this:

(RKF2 > 0) * 0 + RKF1

Then just suppress the zeroes so that they won't appear..

OR

2.b) You create a CONDITION for RKF2 = 0 so that only those customers who have transactions for the year entered in the variable will appear..

NOTE:

You may use and KF as long as it will input greater than 0 if a customer has transaction..

Regards,

Loed

[former_member374954 · Accepted solution]

Did not work.