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
Quote from: Shlan on 13 May 2015 12:25:28 AM
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?
Sorry for that Lynn. I have managed to find out the DB is a cube
Quote from: Shlan on 27 May 2015 05:17:14 PM
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?