Running total in PowerCubes

[yoanka]

Hi,

I'm trying to make a variable that shows a cumulative sum across time dimension in a multidimensional cube. There is option "running-total" in Architect but it doesn't work for Transformer. Is there any way to create such variable in Transfromer?
I will appreciate any hints.

Joanna

 

[goldsmt]

Running totals can be achived when writing reports in powerplay reporter mode. Select the column / row required and then the calculate -> accumulate option from the menue bar

Tony Goldsmith

 

[yoanka]

Hi goldsmt,

You're right, it can be done in Reporter mode, but then you cannot dynamically drill down in a cube.
What I would prefer there was an automatic measure, available in Transformer and then in Explorer mode.

Anyway, thanks a lot!