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
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
I believe this is a dimensional package. Any suggestions?
What is the comparison against? Time dimension?
try doing something like:
[Measure] - tuple([Measure],prevMember(currentMember([Cube].[Tim Dimension].[Time Hierarchy])))