topic Re: Totals and Subtotals on Summary Tables in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Totals-and-Subtotals-on-Summary-Tables/m-p/110729#M9465 <HTML><HEAD></HEAD><BODY><P>Thank you i appreciate it, that really helped!</P></BODY></HTML> Tue, 30 Oct 2012 15:29:01 GMT CesarOmarHR 2012-10-30T15:29:01Z Totals and Subtotals on Summary Tables https://communities.sas.com/t5/SAS-Enterprise-Guide/Totals-and-Subtotals-on-Summary-Tables/m-p/110727#M9463 <HTML><HEAD></HEAD><BODY><P>How do i include totals and subtotals when making a summary table on EG?</P></BODY></HTML> Mon, 29 Oct 2012 21:39:40 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Totals-and-Subtotals-on-Summary-Tables/m-p/110727#M9463 CesarOmarHR 2012-10-29T21:39:40Z Re: Totals and Subtotals on Summary Tables https://communities.sas.com/t5/SAS-Enterprise-Guide/Totals-and-Subtotals-on-Summary-Tables/m-p/110728#M9464 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P>&nbsp; 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.</P><P></P><P>cynthia</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/11878i3E4BE07F9F728E3A/image-size/large?v=1.0&amp;px=600" border="0" alt="use_total.png" title="use_total.png" /></BODY></HTML> Tue, 30 Oct 2012 03:01:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Totals-and-Subtotals-on-Summary-Tables/m-p/110728#M9464 Cynthia_sas 2012-10-30T03:01:15Z Re: Totals and Subtotals on Summary Tables https://communities.sas.com/t5/SAS-Enterprise-Guide/Totals-and-Subtotals-on-Summary-Tables/m-p/110729#M9465 <HTML><HEAD></HEAD><BODY><P>Thank you i appreciate it, that really helped!</P></BODY></HTML> Tue, 30 Oct 2012 15:29:01 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Totals-and-Subtotals-on-Summary-Tables/m-p/110729#M9465 CesarOmarHR 2012-10-30T15:29:01Z Re: Totals and Subtotals on Summary Tables https://communities.sas.com/t5/SAS-Enterprise-Guide/Totals-and-Subtotals-on-Summary-Tables/m-p/110730#M9466 <HTML><HEAD></HEAD><BODY><P>STEP 4 of Summary Table Wizard, play with grand total drop down, til you see the totals you want.&nbsp; Shows up on the right side for each selection</P></BODY></HTML> Thu, 01 Nov 2012 19:54:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Totals-and-Subtotals-on-Summary-Tables/m-p/110730#M9466 sasspan 2012-11-01T19:54:34Z