Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Subtotal in SAS VA

Reply
New Contributor
Posts: 4

Subtotal in SAS VA

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

Contributor
Posts: 20

Re: Subtotal in SAS VA

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.

New Contributor
Posts: 4

Re: Subtotal in SAS VA

Posted in reply to thiagoglima

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? 

Ask a Question
Discussion stats
  • 2 replies
  • 141 views
  • 0 likes
  • 2 in conversation