5 Replies Latest reply on Feb 11, 2018 5:55 AM by Jim Dehner

    Previous Year  - date on filter and not on grid

    Gilboa Reif


      i am trying to calculate for example the invoice subtotal and the invoice subtotal of the same period in previous year

      now, i've seen the option to do so with table calculation

      but this doesn't suit my requirement because the date field is not presented on the grid (rows or columns)

      the date is only used  as a filter

      any help on what is the best way to implement that?

      attached screenshot is a simplified version of what i would like: