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?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.