How to creating a new metric based on the Total value?

[KewlGuy007]

Below is a snapshot of my report.
Metrics Approvals Mailed NRR
-------------------------------------------------------Score Band
-------------------------------------------------------
less than 650 1,121 15,333 7.31%
between 650 and 700 6,908 12,084 57.17%
between 701 and 750 11,120 12,583 88.37%
between 751 and 800 9,815 10,321 95.10%
between 801 and 1000 2,104 2,192 95.99%
greater than 1000 22 432 5.09%
-------------------------------------------------------
Total 31,090 52,945 58.72%
-------------------------------------------------------

Score band is actually an attribute.
NRR is my metric which is defined as sum(approvals)/sum(mailed).

Now I need to create another metric called the NRR Index which would be calculated as the value in NRR column divided by the Total NRR value.

e.g. my end report would like as shown below.
NRR Index 0.12=7.31/58.72
Metrics Approvals Mailed NRR (NRR Index)
-------------------------------------------------------Score Band
-------------------------------------------------------
less than 650 1,121 15,333 7.31% 0.12
between 650 and 700 6,908 12,084 57.17% 0.97
between 701 and 750 11,120 12,583 88.37% 1.50
between 751 and 800 9,815 10,321 95.10% 1.62
between 801 and 1000 2,104 2,192 95.99% 1.63
greater than 1000 22 432 5.09% 0.09
-------------------------------------------------------
Total 31,090 52,945 58.72%
-------------------------------------------------------

How can I do it in MSTR? The value 58.72 is a calculated value displayed when I choose to display the subtotals option in MSTR. How can I use that value in the formula of my new metric called NRR Index?

Awaiting your responses.

Thanks!

 

[nlim]

You need to create the denominator as a metric. You can either

- create a metric called NRRTotal as sum(approval)/sum(mailed) but ignoring the dimensionality of "range".
- or you can create a derived metric within the intelligent cube defined as sum(approval){} / sum(mailed) {}.

This is important as you don't want it to break it out by the rows in your report. If you add this metric to your report, it should show 58.72 for all rows.



then create metric NRRINdex as NRR/NRRTotal. This is like creating a % contribution metric.