https://communities.sas.com/t5/SAS-Visual-Analytics/Cross-Tab-Total-not-Total-of-Column/m-p/879574#M17265 <P>Hi,</P><P>&nbsp;</P><P>I have a cross tab which includes several aggregated measures and a calculated output of those, when I display the totals on the crosstab it appears that SAS is calculating this based on the values of the other columns rather than simply giving me the total value of the column. Any ideas how I can just show the total of the column?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rightside13_0-1686148577183.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/84784i1863184DD80CFC9A/image-size/medium?v=v2&amp;px=400" role="button" title="Rightside13_0-1686148577183.png" alt="Rightside13_0-1686148577183.png" /></span></P><P>&nbsp;</P> Wed, 07 Jun 2023 14:36:38 GMT Rightside13 2023-06-07T14:36:38Z https://communities.sas.com/t5/SAS-Visual-Analytics/Cross-Tab-Total-not-Total-of-Column/m-p/879574#M17265 <P>Hi,</P><P>&nbsp;</P><P>I have a cross tab which includes several aggregated measures and a calculated output of those, when I display the totals on the crosstab it appears that SAS is calculating this based on the values of the other columns rather than simply giving me the total value of the column. Any ideas how I can just show the total of the column?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rightside13_0-1686148577183.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/84784i1863184DD80CFC9A/image-size/medium?v=v2&amp;px=400" role="button" title="Rightside13_0-1686148577183.png" alt="Rightside13_0-1686148577183.png" /></span></P><P>&nbsp;</P> Wed, 07 Jun 2023 14:36:38 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Cross-Tab-Total-not-Total-of-Column/m-p/879574#M17265 Rightside13 2023-06-07T14:36:38Z https://communities.sas.com/t5/SAS-Visual-Analytics/Cross-Tab-Total-not-Total-of-Column/m-p/879597#M17266 <P>&nbsp;You might want to look at the solution in this post:&nbsp;<BR /><BR /><A href="https://communities.sas.com/t5/SAS-Visual-Analytics/Total-for-an-averaged-data-element/m-p/840765#M16594" target="_blank">https://communities.sas.com/t5/SAS-Visual-Analytics/Total-for-an-averaged-data-element/m-p/840765#M16594</A>&nbsp;</P> Wed, 07 Jun 2023 15:31:16 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Cross-Tab-Total-not-Total-of-Column/m-p/879597#M17266 Madelyn_SAS 2023-06-07T15:31:16Z