Metric with acumulated values.

[AnaFlor]

Hello,

I have a metric that has the following values for months:
January - 1
February - 2
March - 3

I want that in the report appears the following
January - 1
February - 3
March - 6

I want that the value of the month is the sum of the month plus the previous months that are in the report.

How can I do that?

Thanks

 

[JRO061601]

You can use the 'RunningSum' function to build your metric. It is found in Schema Objects > Functions & Operators > Functions > OLAP Functions.

 

[AnaFlor]

This function didn´t work how I was expecting too.

Can you give some more information?

Thanks

 

[JRO061601]

You should be able to define a metric this way:

RunningSum(SOME_FACT)

Then build a report putting the metric along the column headers and 'Month' along the row headers. Should give you what you are looking for.

If not, please post your metric definition and how you are building your report. And the SQL.

 

[AnaFlor]

Hello,

The problem is that I cannot create a metric with runningsum and a fact, only with a metric.

How can I solve this?

Thanks

 

[JaC74]

Then make a metric on your Fact, then create a nother metric that does a runningsum the metric you just created.

First metric = MAX(FACT)
Second metric = RunningSum(METRIC_ABOVE)

 

[AnaFlor]

Thanks for all your help.

Just to Know. After you told me about this function I've tried the moving sum too and it worked.

I just sorted it by all the months of the year that appear in the report.

Thanks