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
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:
Best regards.
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?
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.
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.