turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- BI
- /
- Visual Analytics
- /
- Aggregated Measure in Show column Total

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-19-2014 03:50 AM

Hi everyone,

I'm new on SAS VA 6.2 and I have a question regarding on how SAS VA handles Aggregated Measure on Column Totals. When I say Totals it is the sum of the the numbers inside that variable or column. For example, I have variables A, B and C. Variable A is an Aggregated Measure while B is a Measure and to get variable C I would do the computation A*B in Aggregated Measure. If I put them on Cross tab and click on Show column total in it's Properties, instead of getting the sum of Variable C in the totals I would get the values of Total of A * Total of B. Is there a way I would get the Sum of Variable C in the totals for aggregated measure?

Thanks.

Albert

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-25-2014 06:54 AM

May be I've havente understund your problem but if the istuation is this

a 100 10

b 50 30

c 20 40

d 10 20

Then

sum c = 100*10+50*30+ 20*40+10*20

In this case not use the aggregate measure but the 'normal measure

sum c = (100+50+20+10)*(10+30+40+20)

In this case use the aggretagate measure with sun for group