COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sravantig on 12 Mar 2012 03:00:39 PM

Title: Suggest an expression/filter
Post by: sravantig on 12 Mar 2012 03:00:39 PM
For my chart
Creating a chart
x axis- Jan, Feb...
Measure- Overtime%
y-axis? <-------------- HELP REQUIRED

I have my level set [Department] which consists of different departments

I need to show on my chart, number of departments below 25% overtime.

Please help me....


Title: Re: Suggest an expression/filter
Post by: cognostechie on 12 Mar 2012 05:39:37 PM
The measure would probably be Number of Departments on Y-Axis and below 25% would be the filter.
Title: Re: Suggest an expression/filter
Post by: sravantig on 13 Mar 2012 10:28:03 AM
My departemnts consists of many children .... my question is how do I get my complete count of departments