2 Replies Latest reply on Apr 3, 2018 6:18 AM by Vibhanshu jain

    How do I find the difference and the top gainers and losers?

    Vibhanshu jain

      I am trying to find the week on week difference in revenue for all my customers. After which I want to try to find the top 10 customers in terms of growth for the last week(week 11). I have tried using this formula for the difference

       

      zn(Sum(revenue))-zn(lookup(sum(revenue),-1) to find the difference between different weeks.

       

      Then I am using the rank function on the difference and putting the week in filter to week 11. this doesn't seem to be working

       

      The flow is

       

      Auction ->product->customer-> revenue

       

      Do you guys have any ideas as to why it is not working ???

       

      Edit: attaching workbook

       

      Message was edited by: Vibhanshu jain