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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Last Period

Started by ballytech, 11 Apr 2008 01:18:24 PM

Previous topic - Next topic

ballytech

I am fairly new to BI reporting, so this is probably a simpler question for everyone else. I have a statistical report by month that subtotals by quarter. I need to have the quarter "subtotal" be the last period of the quarter. So if I have 100 for Jul, 200 for Aug, and 300 for Sep I need the Q1 subtotal to be 300 and not 600.

Can anybody help? I tried doing the lastperiods function but that doesn' seem to be working. Any help is greatly appreciated.

acabugason

ballytech,

Do you have a cube or relational datasource? Also, from your description, it looks like your data is a balance of the month-over-month activity. Am I correct?