topic Subtotal in SAS VA in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Subtotal-in-SAS-VA/m-p/467414#M10360 <P>Hello</P><P>Is there an equivalent to Excels =SUBTOTAL(9;B2:B12) and =SUM(9;B2:B12), that can calculate the latter when using a filter in SAS VA?</P><P>Thanks</P> Mon, 04 Jun 2018 14:24:44 GMT FilipJ 2018-06-04T14:24:44Z Subtotal in SAS VA https://communities.sas.com/t5/SAS-Visual-Analytics/Subtotal-in-SAS-VA/m-p/467414#M10360 <P>Hello</P><P>Is there an equivalent to Excels =SUBTOTAL(9;B2:B12) and =SUM(9;B2:B12), that can calculate the latter when using a filter in SAS VA?</P><P>Thanks</P> Mon, 04 Jun 2018 14:24:44 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Subtotal-in-SAS-VA/m-p/467414#M10360 FilipJ 2018-06-04T14:24:44Z Re: Subtotal in SAS VA https://communities.sas.com/t5/SAS-Visual-Analytics/Subtotal-in-SAS-VA/m-p/468047#M10386 <P>Hi <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/213560">@FilipJ</a>,</P><P>&nbsp;</P><P>You can do it with a Crosstab, please, read the Crosstab properties documentation through this link:&nbsp;<A href="http://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#n1d46th0qjjhxdn16a6uj2bfxuzt.htm" target="_blank">http://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#n1d46th0qjjhxdn16a6uj2bfxuzt.htm</A></P><P>&nbsp;</P><P>How someone with a similar issue has solved it:</P><P><A href="https://communities.sas.com/t5/SAS-Visual-Analytics/Row-Total-Row-Subtotal-in-SAS-Visual-Analytics/td-p/203101" target="_blank">https://communities.sas.com/t5/SAS-Visual-Analytics/Row-Total-Row-Subtotal-in-SAS-Visual-Analytics/td-p/203101</A></P><P>&nbsp;</P><P>Best regards.</P> Wed, 06 Jun 2018 13:39:31 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Subtotal-in-SAS-VA/m-p/468047#M10386 thiagoglima 2018-06-06T13:39:31Z Re: Subtotal in SAS VA https://communities.sas.com/t5/SAS-Visual-Analytics/Subtotal-in-SAS-VA/m-p/469211#M10428 <P>Hi.</P><P>&nbsp;</P><P>Thanks for answering, but I am looking for a solutioner where, if I use eg. filter. the total will stay the same.</P><P>&nbsp;</P><P>Lets say I have 1000 in 2015, 2016, 2017 making it&nbsp;a total of&nbsp;3000.</P><P>If&nbsp;I use filter Year&gt;2015 the subtotal should be 2000 and total still 3000.</P><P>&nbsp;</P><P>How to?&nbsp;</P> Mon, 11 Jun 2018 12:59:33 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Subtotal-in-SAS-VA/m-p/469211#M10428 FilipJ 2018-06-11T12:59:33Z