BookmarkSubscribeRSS Feed
john83
Calcite | Level 5
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
1 REPLY 1
AngelaHall
SAS Employee
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

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 586 views
  • 0 likes
  • 2 in conversation