https://communities.sas.com/t5/SAS-Web-Report-Studio/How-to-Subtract-quot-Dimension-Level-quot-from-quot-Total-quot/m-p/30573#M472 John,<BR /> Is this using an OLAP cube source? If so...<BR /> <BR /> 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.<BR /> <BR /> 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.<BR /> <BR /> Example of the SUM function = <A href="http://msdn.microsoft.com/en-us/library/ms145484.aspx" target="_blank">http://msdn.microsoft.com/en-us/library/ms145484.aspx</A><BR /> <BR /> ~ Angela Thu, 11 Nov 2010 15:05:13 GMT AngelaHall 2010-11-11T15:05:13Z https://communities.sas.com/t5/SAS-Web-Report-Studio/How-to-Subtract-quot-Dimension-Level-quot-from-quot-Total-quot/m-p/30572#M471 Hi Experts,<BR /> 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 .....&lt;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.<BR /> ......... PInc$ PCI$ <BR /> &lt;15........10.....20 <BR /> 20-25......15......35 <BR /> 26-30......30......10 <BR /> 31-35......65......25 <BR /> 36-40......20......80 <BR /> Missing....40......90 <BR /> ----------------------------------------------------<BR /> Total.......180.....260.............<BR /> Missing......40......90........... <BR /> --------------------------------------------------<BR /> TotKnown..??????????? <BR /> ----------------------------------------------------<BR /> Many Thanks,<BR /> John Mayor<BR /> <BR /> Message was edited by: john83 Message was edited by: john83 Tue, 09 Nov 2010 05:13:04 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/How-to-Subtract-quot-Dimension-Level-quot-from-quot-Total-quot/m-p/30572#M471 john83 2010-11-09T05:13:04Z https://communities.sas.com/t5/SAS-Web-Report-Studio/How-to-Subtract-quot-Dimension-Level-quot-from-quot-Total-quot/m-p/30573#M472 John,<BR /> Is this using an OLAP cube source? If so...<BR /> <BR /> 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.<BR /> <BR /> 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.<BR /> <BR /> Example of the SUM function = <A href="http://msdn.microsoft.com/en-us/library/ms145484.aspx" target="_blank">http://msdn.microsoft.com/en-us/library/ms145484.aspx</A><BR /> <BR /> ~ Angela Thu, 11 Nov 2010 15:05:13 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/How-to-Subtract-quot-Dimension-Level-quot-from-quot-Total-quot/m-p/30573#M472 AngelaHall 2010-11-11T15:05:13Z