2 Replies Latest reply on Feb 25, 2019 1:27 AM by Martin Landen

    How to sort on a Table Calculation along the same measure over time

    Martin Landen

      Hi I have a table that display a "Measure Y" over time. The "Measure Y" is a calculated field which is a sum(Field A) / sum(Field B). I am tracking the Measure on a grouping variable Retailer over time.

       

      What I am really interested is the difference between weeks and have introduced a table calculation Diff = "Measure Y - lookup(Measure Y,-1)" .

      I would actually like to sort and filter the whole table on the "Diff to previous Week" for the "Latest Week" (in this case week 4). Is this even possible?