BookmarkSubscribeRSS Feed
FilipJ
Calcite | Level 5

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

2 REPLIES 2
thiagoglima
Obsidian | Level 7

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
Calcite | Level 5

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? 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1443 views
  • 0 likes
  • 2 in conversation