more on running-total()

[axxo]

I am having trouble doing a running total of the following data item called [Total]

[Total] has expression
total( [measure] within set set([row_item])) +[Journal]

An ideas??

[CognosPaul]

I've never had luck using running functions with olap.

Try this instead:

total([Sales]
within set periodsToDate (
[Cube].[Dates].[Years].[All],
currentMember ([Cube].[Dates].[Years])
))