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

running-total for auto???

Started by ejbaron, 08 Mar 2007 12:14:57 PM

Previous topic - Next topic

ejbaron

I am trying to create what I think should be a running-total calculation.Ã,  however, I want the "for" option to be dynamic, depending on how granular the user chooses to display the running total, that's how it should reset.Ã,  The user may want to see a running-total grouped at a high level, and then slowly add more granularity to the display and see the running-total become more granular.

I'm creating the calculation in Report Studio, but ultimately want to move it to Framework Manager where I can include it in an IQD file for a cube.Ã,  I'm open to the suggestion of putting the running-total calculation in Transformer if that will produce the right results, but I haven't gotten that far yet.

Thanks all!
EJB

bdybldr

Try using...

RUNNING-TOTAL([fieldName] for CASE... WHEN...THEN...ELSE...)

In other words, use a case statement to determine the options selected by the user for grouping your data items.Ã,  If you provide more information, we can better assist you.

MargaretAnderson

I think we all get a little bit distracted from the main topicstarter's theme