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

[RS] Running Totals in a crosstab

Started by Chicken Head, 15 Jun 2006 03:40:39 AM

Previous topic - Next topic

Chicken Head

Has anyone tried to do this? I've attempted all ways but without producing the correct result, even Cognos support are having difficulty.

I have product type as my rows, nominal period (Calendar) as my main column but with measure edges below of expenditure amount and transaction amount. In addition to this I have a calculation adding the expenditure and transaction columns together to create an Actual column, this is the column I would like a running total on.

I've tried the basic running total calculation (running-total([Actual] for report) ) but the figures are totally nonsencial.

Thanks

Mark

JGirl

I'm picturing your crosstab as something like the following (with CalcMeas3 as the accumulating measure).  Also try tweaking the aggregation settings of the measure columns and the calculation column...

Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, Period1Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Period2
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Meas1Ã,  Meas2Ã,  CalcMeas3Ã,  Ã,  Meas1Ã,  Meas2Ã,  CalcMeas3
ProdTypeAÃ,  Ã,  Ã,  5Ã,  Ã,  Ã,  3Ã,  Ã,  Ã,  Ã, 8Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 2Ã,  Ã,  Ã,  2Ã,  Ã,  Ã,  Ã, 12 (ie. 8 + 4)
ProdTypeBÃ,  Ã,  Ã,  1Ã,  Ã,  Ã,  1Ã,  Ã,  Ã,  Ã, 2Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 1Ã,  Ã,  Ã,  1Ã,  Ã,  Ã,  Ã,  4 (ie. 2 + 2)

Try using (running-total([Actual] for RowMeasureName) )

eg. (running-total([Actual] for [Product Type]) )

J