Restrict report based on combination of chars

[Former Member]

Hi there, i would like to restrict data displayed on my report depending on a combination of characteristic values.

e.g.

Report has Pricing Condition Type, Billing doc Type and Amount.

If Pricing Cond Type = ABC then do not display Billing Doc Types 1,2 and 3 for Pricing Cond Type = ABC only.

any help will be greatly appreciated.

Running 3.1

[Former Member · Accepted solution]

Hi Alan,

1: Create first restricted KF(KF1)

2: Restrict to Condition Type = ABC and Bill Doc =3

3: Create Second Restricted KF (KF2)

4: Restrict to Condition Type = ]ABC[ (Exclude ABC) and Bill Doc = ]3[ (Exclude Bill Doc 3 ie for other Bill Docs like 1,2)

5: Create Third Formula (Calculted) Key Figure (KF3)

6: Formula = KF3 = KF1 + KF2

Hide KF1 and KF2

Regards

Happy Tony

[Former Member · Accepted solution]

Well Happy Tony, you have made me happy!

The solution you proposed did not quite work but it put me down the right path.

Basically I built a restricted KF based on the criteria that I wanted to exclude ie.

Pricing Cond = ABC

Billing Doc Type = 1,2,3

I subtracted this from my original KF, hid the other and job done, thanks.

[Former Member · Accepted solution]

Hi Alan,

good learning! So go on

Regards

Happy Tony

[Former Member]

Hi Alan,

your condition is not clear.

this is ok..

If Pricing Cond Type = ABC then do not display Billing Doc Types 1,2 and 3

then wat is this

for Pricing Cond Type = ABC only.

make it clear.Tell the business requirement.

Regards,

San!

[Former Member]

Hi San,

I mean that I want to see billing doc types for all other Pricing condition types

e.g.

Pricing Cond = ABC and Bill Doc = 1 then do not display

Pricing Cond = ABC and Bill Doc = 2 then do not display

Pricing Cond = DEF and Bill Doc = 1 then display

Pricing Cond = DEF and Bill Doc = 2 then display

Pricing Cond = ABC and Bill Doc = 3 then do not display

[Former Member]

hi Alan,

1)Drag your Pricing Cond and Billing Doc in Rows.

2) In columns

2.1 Right click-> New Structure->Right Click-> New Selection. Names as "KF1".

now Drag your Kiy figure Amount, Pricing Cond and Bill doc.

Now Double click on Pricing Cond -> Drag 'ABC' in rite panel. press ok.

Now Double click on Billing Doc and Drag '1','2','3' in right panel. Now right click on '1'->choose exculde from selection.similarly for '2' and '3'.

2.2) Again Right click the New structure and create a New selection "KF2"

Now Drag your Kiy figure Amount, Pricing Cond and Bill doc.

Now double click on Prciing Cond and drag value 'ABC' in right panel and exculde from selection.press ok.

3) Again Right click the New structure and create a New Formula "AMount". Double that "KF1" (see bottom in panel)

then press "+" sign and again double click on "KF2".

Basically adding "KF1" and "KF2".

4) Right click on "Kf1"-> hide it.Same for "KF2".

5)save ->execute.

Hope i m clear.

Regards,

San!

[Former Member]

Hey San, thanks for the inputm but as you can I have managed to come to solution, have awarded points for you very helpful answer