I'm looking to show (and by able to filter by) the movement between numbers in a table between each month of a year (as of date) per account.
For example, between September 2015 and October 2015 the amount of money paid in fees went from 10 to 25, therefore had a movement of 15.
I have done this by making an in table calculation, however this does not seem to let me group by amounts from these new calculated numbers - for example if I wanted to group any numbers that were above 50, 40-50, 30-40 etc - I want to be able to highlight my data by these groups if possible?
Thanks in advance!
Are you still hoping for help with this question? If so, please upload a packaged workbook so we can take a look at your work and try to help. If you've found a solution, please let us know!