topic Editing of 'totals' & 'subtotals' in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Editing-of-totals-subtotals/m-p/194332#M1505 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can we edit “Totals” and “Subtotals” in SAS VA?</P><P></P><P></P><P></P><P><EM>For example:</EM></P><P></P><P>Calculation (aggregated measure) for Column 2 below is:</P><P></P><P><STRONG>Sum[by group](Column1) / Sum[by group](Column 3)</STRONG></P><P></P><P></P><P></P><P></P><P><STRONG style="text-decoration: underline;">Column 1 Column 2 Column 3</STRONG></P><P>10,000 500 20</P><P>20,000 1000 20</P><P></P><P><STRONG style="text-decoration: underline;">Subtotal</STRONG></P><P><STRONG style="text-decoration: underline;">Column 1 Column 2 Column 3</STRONG></P><P>30,000 750 40</P><P></P><P>Thanks,</P><P>Sarthak</P><P></P><P></P><P>&nbsp; <SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">I would like to change the Subtotal for Column 2 to give me 500 + 1000 = 1500 instead of 30,000 / 40 = 750.</SPAN></P></BODY></HTML> Mon, 13 Apr 2015 11:16:13 GMT sarthak89 2015-04-13T11:16:13Z Editing of 'totals' & 'subtotals' https://communities.sas.com/t5/SAS-Visual-Analytics/Editing-of-totals-subtotals/m-p/194332#M1505 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can we edit “Totals” and “Subtotals” in SAS VA?</P><P></P><P></P><P></P><P><EM>For example:</EM></P><P></P><P>Calculation (aggregated measure) for Column 2 below is:</P><P></P><P><STRONG>Sum[by group](Column1) / Sum[by group](Column 3)</STRONG></P><P></P><P></P><P></P><P></P><P><STRONG style="text-decoration: underline;">Column 1 Column 2 Column 3</STRONG></P><P>10,000 500 20</P><P>20,000 1000 20</P><P></P><P><STRONG style="text-decoration: underline;">Subtotal</STRONG></P><P><STRONG style="text-decoration: underline;">Column 1 Column 2 Column 3</STRONG></P><P>30,000 750 40</P><P></P><P>Thanks,</P><P>Sarthak</P><P></P><P></P><P>&nbsp; <SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">I would like to change the Subtotal for Column 2 to give me 500 + 1000 = 1500 instead of 30,000 / 40 = 750.</SPAN></P></BODY></HTML> Mon, 13 Apr 2015 11:16:13 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Editing-of-totals-subtotals/m-p/194332#M1505 sarthak89 2015-04-13T11:16:13Z Re: Editing of 'totals' & 'subtotals' https://communities.sas.com/t5/SAS-Visual-Analytics/Editing-of-totals-subtotals/m-p/194333#M1506 <HTML><HEAD></HEAD><BODY><P>I am also wondering the same Sarthak89.</P><P>Is it possible to edit default column totals/subtotals for a crosstab object?</P></BODY></HTML> Mon, 01 Jun 2015 10:00:15 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Editing-of-totals-subtotals/m-p/194333#M1506 ZoBuyani 2015-06-01T10:00:15Z Re: Editing of 'totals' & 'subtotals' https://communities.sas.com/t5/SAS-Visual-Analytics/Editing-of-totals-subtotals/m-p/357729#M7143 <P>did you sort this out..?</P> Thu, 11 May 2017 01:58:43 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Editing-of-totals-subtotals/m-p/357729#M7143 Sathya_rsr 2017-05-11T01:58:43Z