HI,
Please help me!!!!
does anybody know how to use "running-total" function in Framework Manager? this is my case:
In FM I created a Measure Dimension from a Query Subject:
Profit: xxxx (xxxx is a query item of my Query Subject)
then, I need another measuer as: Running-Total(xxxx)
everything seems ok but when I am going to use Running-Total(xxxx) in the report, for example:
Year Profit Running-Total(xxxx)
2002 10 ???
2003 12 ???
2004 5 ???
2005 3 ???
the result is totally unsane; if I create a new query item in Report Studio as Running-Total(xxxx for [Year]) it works ok.... but i cannot put this in FM 'cause i don't know which kind of aggregation I need.
thanks to everybody!!!!!
You either define the scope in the framework dataitem expression or you use an expression in report studio. I believe there is no way - AFAIK - to add the scope in second instance tot the running-total (this leads to incredibly bloated values)