Dynamic filter and calculations

Hi all. I'm a bit stuck on this one. I have a list of customers and their sales. If sales is above 1000 in total the last 12 months i want to tag them with "High", the rest of customers "Low". This...