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?
... View more