filter criteria not working in report run
There is a Z report in the system and it's giving out the required data.
while choosing the 'multiple selection' arrow in the report, I want to exclude some materials and a billing category from the report run(both these fields are there in the z report). I have marked a material (say x) for exclusion in the 'exclude value' tab '1 single val' (with the sap red light icon). Coming out I also see the 'do not select:Equal to' red rectangle on the main report field(both Billg. cat field & Material field).
Running the report does not exclude the material X, but it is excluding the billing category.This is not consistent. It is excluding one field but including the other field, while both need to get excluded, any reasons why ? It seems the filtering mechanism is not working for the material , my question is then how to exclude the material in this report. am I doing anything different or is this a bug .
kindly help me out
Message was edited by: