I am trying to create an autosum to display totals for a particular column at
the bottom of the colum, however I only want it to show the totals for the
data visible at that time. E.g ig I have selected certain variables from the
drop down columns at the top (uk/ireland figures for example) I want it to
update the autosum total to just show the total for these variables (e.g.
Sales figure UK/Ireland and not other countries that are hidden) rather than
still showing the total for the whole column.