2 Replies Latest reply on Jun 20, 2018 2:16 AM by Isabella Sharpley

    Calculating the wow % change using a parameter

    Isabella Sharpley

      Hi,

       

      I have been putting together a table to show the current week, previous week values of data for different locations.

       

      I have done in in such a way so that the current week is a field heading , using a "WeekSelect" parameter.

       

      I now want to add in a wow percentage change for these two columns - any help on this will be very appreciated!

       

      Basically  I need the field headers : Location, current week (or date of current week), previous week, measure date, percentage change

       

      I have attached my current wb.

       

      Thanks!