3 Replies Latest reply on Jun 11, 2018 8:03 AM by Zhouyi Zhang

    Calculate Delta % from previous time period per customer

    Miquell Kleuters

      Hi all,


      As i am trying to create a view which show the difference % from previous time period for customers i got kinda stuck.


      Table calculation works is only relatable to the previous data in a chart and does not refer back to the customer's specific data from last time period.


      It might work by using a calculation of this month and a calculation from last month where you specify the customer in the calculated field.


      As my knowledge is not going that far I am asking you for help.


      To illustrate you can use my template which is attached to this discussion.


      The ideal outcome would be:


      Customer on X axis

      Delta % as value without having to show current and last months data.


      Thank you,