Calcite | Level 5

## How to Subtract "Dimension Level" from "Total" in WRS?

Hi Experts,
I need urgent help on the following issue. I am creating a web report. The table consists of 2 measures(present on column side). Two Measures arePInc\$, PCI \$. The table consists of "Age Group" Dimension(row side). The "Age Group" dimension has 6 levels .....<15,(20-25), (26-30),(31-35), (36-40),Missing. I am able to total all the "Level" values using the "Total option" in the WRS. I am not able to subtract "Missing" level from "Total". Could anyone please provide solution for this question. I will be very greatful to you.
......... PInc\$ PCI\$
<15........10.....20
20-25......15......35
26-30......30......10
31-35......65......25
36-40......20......80
Missing....40......90
----------------------------------------------------
Total.......180.....260.............
Missing......40......90...........
--------------------------------------------------
TotKnown..???????????
----------------------------------------------------
Many Thanks,
John Mayor

Message was edited by: john83 Message was edited by: john83
SAS Employee

## Re: How to Subtract "Dimension Level" from "Total" in WRS?

John,
Is this using an OLAP cube source? If so...

You could consider creating a Calculated Member in OLAP Cube Studio to use in the Info Map (and subsequent WRS report). Otherwise you would need to create this new measure in your Information Map.

In both methods, you will need to utilize MDX code to create the calculation. I would actually recommend opening the cube in Enterprise Guide and creating/testing the calculation here (create a new 'calculated measure'). Then saving the calculation back into the OLAP Cube via the Cube Studio 'calculated member' widget.

Example of the SUM function = http://msdn.microsoft.com/en-us/library/ms145484.aspx

~ Angela
Discussion stats