same data items different filters

[ryansou]

Hello,

I am a brand-new Cognos Report Studio user, so please forgive me if this has been covered in a previous post. I have not been able to find a solution.

I want the same data item in my report two times, but I want a different filter on each of them. For one of the data items, I'd like to show all activity; for the other one, I'd like to show only some activity.

Thoughts on how to handle this?

Thanks!

[sdf]

First of, are you using a relational or a dimensional source?
And what is your goal? Where and how are you gonna show this in a report?

ideally you can create two instance of your data item. (can copy paste or create a new one with different name)
then add a filter to each.

you can drag dataitem1 into the filters section and in the menus available you can select one or select many.
use "in" or "="
select the value/values you want.

do this to the dataitem2 as well.

Just try this for relational.

In dimensional you can use the set function or except function.

[ryansou]

Thanks for your thoughts.

It's a relational database.

I'm trying to pull all of our grants, which are accounted for in separate funds, into a report and show which ones get indirect costs. Two of the data items--YTD activity--are identical. I'm filtering on the indirect costs account code; however, when you do this, both YTD activity data items are filtered on this account code. What I want, though, is for one YTD activity data item to be filtered on the indirect costs account code and the other to return all YTD activity less revenue and indirect costs-i.e., only direct costs.

[sdf]

it will be better, if you can describe your goal specifically.
How are you showing the data? Via List/crosstab?

Or much better, you can plot what you want to do in excel, have a screenshot and post it here.