If you are unable to create a new account, please email support@bspsoftware.com

Author Topic: Restricting the Measure value by date range  (Read 3182 times)

s.surajs

  • Guest
Restricting the Measure value by date range
« 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.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,707
  • Forum Citizenship: +677/-10
  • Cognos Software Muppet
Re: Restricting the Measure value by date range
« Reply #1 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.
Meep!