1 Reply Latest reply on Oct 28, 2016 2:42 PM by diego.medrano

    How to show movement between two numbers

    Henrietta Bathurst

      Hi,

       

      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!