Alrighty... I have set up what I can. However, I have one hurdle.

The revenue info of my 100 and 200 department need to be available to the marketing department, but not the expenses... only the expenses of the 600 department are available to them.

So, my report has been created listing revenues in a range, then the 600 expenses have been listed specifically. (-600)

Problem with this is that whenever the report is specific to a department, any other department can read it.

Maybe I am missing something.