06-06-2018 09:39 AM
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:
06-11-2018 08:59 AM
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.