cancel
Showing results for 
Search instead for 
Did you mean: 

Filtering in the Report

Former Member
0 Kudos

Hai Pals

I have a situation here i have to filter the values for one

characteristis value .i want to display all the values othre than

that for that characteristic value .

Here is my scenario i have stock types A B C D E F and i want

to filter the values for C(i dont want values for C).

One solution can be that i can restrict the query for the

values A B D E F but here there is a possibility the stock types

will increase so i can not restrict because by resticting i wont

get the desired results .

other idea i am thinking i know this is the hard way of doing

things ceate a variable for stock type with processing type as

customer exit and write the exit.

is there any other way of doing it easy?

Guide me how i can go about this scenario .

Any ideas will be rewarded.

Cheers..........

Rgds,

Ravindra.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hallo

Better you do an exit or replacement path variable which takes value from another query.

If you exclude some value, index are not taken in consideration. Better to filter including value.

Mike

Former Member
0 Kudos

Hai Mike and Shasi

Thanks for your quick replies. first i want to try what Shasi had suggested because it seems to be easier.

u said restrict and right click the value and exclude from selection but i dont find any exclude in the context window .

here r the steps i followed

1. keep the stock type in the filter and retricted with the type C

2. and right click on the value but it not showing

pls tell me what r the steps to follow.

i think i am missing some

thanks in advance.

Rgds,

Ravindra.

Former Member
0 Kudos

Hallo

When you make a filter, select the value "C", move under filter, then select it, right click, select exclude from selection.

In this case you have excluded it.

Mike

Former Member
Former Member
0 Kudos

Hai Mike

Porbably i didnt understand u Correctly. when i am select C and right click i got four options

1. restrict

2. cut

3. delete

4. paste .

but i dont see the option u r saying.

Thanks in advance

Rgds,

Ravindra.

Former Member
0 Kudos

Hi Ravindra..

He meant..

Right Click on Stock Type --> Restrict > Select C from Left hand box and move it to right hand> then right click on "C" --> Exclude from selection..

Hope it is clear

Ashish..

Former Member
0 Kudos

Thanks Ashish Shashi and Mike,

i very much appreciate that.

any way i assigned points.

Cheers.........

Rgds,

Ravindra.

Answers (1)

Answers (1)

Former Member
0 Kudos

hi do a restriction on the stock type "C" and right click in the restriction area and click "exclude from the selection"

reward if helps