Crosstab Individual Column filter

[Shlan]

Being relatively new to Cognos Report Studio Im trying to create a crosstab and place a filter on an individual column.

                          Active Projects | Total Projects   
Project Manager


Both Columns use the 'Project Count' Data item but I need to place a filter on the Active Projects Coulmn

There are more columns and other filters but they are working correctly.

Thanks

[Lynn]

Being relatively new to Cognos Report Studio Im trying to create a crosstab and place a filter on an individual column.

                          Active Projects | Total Projects   
Project Manager


Both Columns use the 'Project Count' Data item but I need to place a filter on the Active Projects Coulmn

There are more columns and other filters but they are working correctly.

Thanks

Take a moment to read the forum etiquette sticky post. You don't mention if you have a relational or a dimensional source. I don't entirely understand what you are asking. Presumably project count is the default measure? How are active and total projects derived? Are they report expressions or members in some other dimension? What are you trying to achieve with a filter on active projects?

[Shlan]

Sorry for that Lynn. I have managed to find out the DB is a cube

[Lynn]

Sorry for that Lynn. I have managed to find out the DB is a cube

So we've identified the type of data source. Care to answer any of the other questions I asked?