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
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