Running Difference in Cognos

[rishipopat]

I need to create a running difference(difference of the current row and its previous row) for each row in a table/crosstab. Please let me know what is the best way to implement it in Report Studio

Thanks

[MFGF]

Ummmm.... You might try using the running-difference summary in a query calculation? Is this a cross tab based on a relational package or a dimensional package? If it's relational, it should work ok, but we may need to get more inventive for a dimensional source.

Cheers!

MF.

Sent from my iPad using Tapatalk HD

[rishipopat]

I believe this is a dimensional package. Any suggestions?

[CognosPaul]

What is the comparison against? Time dimension?

try doing something like:
[Measure] - tuple([Measure],prevMember(currentMember([Cube].[Tim Dimension].[Time Hierarchy])))