Subtotal in SAS VA

[FilipJ]

Hello

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?

Thanks

[thiagoglima]

Hi @FilipJ,

You can do it with a Crosstab, please, read the Crosstab properties documentation through this link: http://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#n1d46th0qjjhxdn16a6uj...

How someone with a similar issue has solved it:

https://communities.sas.com/t5/SAS-Visual-Analytics/Row-Total-Row-Subtotal-in-SAS-Visual-Analytics/t...

Best regards.

[FilipJ]

Hi.

Thanks for answering, but I am looking for a solutioner where, if I use eg. filter. the total will stay the same.

Lets say I have 1000 in 2015, 2016, 2017 making it a total of 3000.

If I use filter Year>2015 the subtotal should be 2000 and total still 3000.

How to?