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 in Crosstab report

Started by phani1979, 04 Mar 2015 01:50:20 PM

Previous topic - Next topic

phani1979

Hello,
I'm doing Crosstab report in report studio against relational database
Rows. Date , SubSystem
Columns: Department, Year, Desc
Measure :Actual
Prompt : Year, Month, Department.
business logic for report is to find activity for actual $$ in selectedYear/selected month/dates and also  Prior months activity Balance Forward for  selected departments.
I could write calculation to find total, total( [actual] for [desc],[year],[system],[date]) as Dept total
now how do i write condition or cal for getting running-total of [Depttotal].
here's calc for running-total i written..
running-total([depttotal] for [desc],[year],[department])

so how do I write a calc to get the running total even if system is having two records for single day?

phani1979

I figured my self. all columns are defined as varchar or char data types on crosstab columns, so i have to change datatypes and redefine the grouping  in  new query subject in fm apply the determinants,  i guess it start.

thanks