Totals and Subtotals on Summary Tables

[CesarOmarHR]

How do i include totals and subtotals when making a summary table on EG?

[Cynthia_sas · Accepted solution]

Hi:

  If you are using the Summary Tables Task, then when you are in the table designer, look for an available CLASS variable that is labelled Total (ALL) -- you can drag that item to any dimension in order to produce subtotals and totals. See this example of a table design, there I have AGE nested with SEX as the CLASS variables and get the mean of HEIGHT in the columns, then I have both sub-totals and a total on the table design.

cynthia

[CesarOmarHR]

Thank you i appreciate it, that really helped!

[sasspan]

STEP 4 of Summary Table Wizard, play with grand total drop down, til you see the totals you want.  Shows up on the right side for each selection