COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Query Studio => Topic started by: s.surajs on 22 Feb 2011 02:38:04 AM

Title: Restricting the Measure value by date range
Post by: s.surajs on 22 Feb 2011 02:38:04 AM
Hi,

Is there anyway we can restrict the measure value by date range ?? I would like to show my billing value in my report as a daily number as well as for the whole month.

Thanks.
Title: Re: Restricting the Measure value by date range
Post by: MFGF on 22 Feb 2011 07:38:55 AM
Hi,

The only way I can think of showing both of these values at once is to display the daily numbers as a list column, and group on your Month column to get monthly values in the footer a t the end of each group.

If you want to restrict the dates to a particular range, you will need to select the date column and add a filter based on it.

Regards,

MF.