Query Designer : Unable to exclude combination of data

[Former Member]

Dear Experts,

My query structure is

Rows : Sales Organisation , Distribution channel , Division

Columns : Sales Value , Debit Note , Credit Note , Net Sales

Free Char : Company code, Bill doc Date, Customer,material

I am unable to exclude the combination of sales organisation and

distribution channel.

I want to exclude sales organisation (6100) with distribution channel

(50). But when we exclude both the values,entire sales organisation

6100 is getting excluded.

Also entire distribution channel 50 is getting excluded.

I want only the combination of 6100 and 50 to be excluded.

Is there any way by which we can acheive this ?

Regards,

Manish

[Former Member]

hi

try creating a condition for this and use "AND" condition not "OR" it will work fine

Nidhi

[Former Member]

Hi nidhi ,

As per my knowledge Conditions can apply to Key Figures only , you can not exclude characteristic values through that.

Can you be more specific about it and give step by step solution using conditions .

Rows : Sales Organisation , Distribution channel , Division

Columns : Sales Value , Debit Note , Credit Note , Net Sales

I want to exclude combination Sales org - 6100 and Dist Chan- 50

6100 10

6100 20

6100 50 - > Only this combination to be excluded

6200 10

6200 50

Regards,

Manish

[Former Member]

Hi Manish

I found that you can exclude this using customer exit. You have to create a variable with customer exit and restrict the sales organisation with this variable and in the customer exit code should be written to avoid only the combinatin of sales organisation and distribution channel....

Regards

N Ganesh

[Former Member]

Hi

You can create a restricted key figure which includes your key figure and the sales organisation and distirbution channel . You can use exclude for the sales organisation 6100 and distribution channel 50 and it will work fine

You can select this restriced key figure in the place of your original key figure and it will work fine....

Hope this helps

Cheers

N Ganesh

[Former Member]

Dear Ganesh,

It didn't helped me . When i created restricted KF the result was exclusion of both the categories ( Sales Ord 6100 and Distribution channel 50 ) .

I hv done in other way using customer group restricted to certain sales org and problem was solved.

But we need to findout solution for this problem.

Regards,

Manish

[Former Member]

Hi

Have you tried creating a condition for the sales organisation excluding only that distribtuion channel

Please try

Hope this helps

Regards

N Ganesh