I would like to filter a list to include only those accounts which are trending down in total sales for the last three months. In this example for instance "C Firm" has trended down for the last 3 months, with each month sales lower than the previous. How would I create a filter to only show the accounts that meet this criteria?
This article might be helpful for what you're trying to do:
I had a look at your sample.twbx, pretty sure the following gives you what you're after:
Which will return:
Let me know if you have any issues with this...