5 Replies Latest reply on Oct 4, 2018 6:02 AM by Diana Prado

    % Change Current Month vs Rolling 12 Month Avg.

    Diana Prado

      Hello,

       

      This is my first post so please ask questions if I am not being clear enough. I really appreciate your help, just want to start by saying that.

       

      Here is some information about my data:

      Column1: Email Campaign Type (ex: news, specials, inspirational, etc)

      Column2: Year (ex: 2016, 2017, 2018)

      Column3: Month (ex: Jan, Feb, Mar, etc)

      Column4: Open (12000, 8345, 1245, etc)

      Column5: Delivered (30000, 40000, 20000, etc)

      Column6: Click (450, 230, 1000, etc)

      (I have lots more values including booking, room nights, conversion, etc)

       

      I want to create a simple chart that shows me the % change from the current month vs the 12 month avg. for each of the different Email Campaign Types, and each of the values (Open, Delivered, Click, and more).

       

      This is what I have so far, but it is obvious to me that the numbers are all wrong:

      This is what my table calculation looks like, it is obviously wrong but I don't know how to fix it. I am not even sure I need to be using a table calculation at all:

       

      Thank you so much!

      Diana Prado