3 Replies Latest reply on Nov 14, 2012 9:29 AM by Shawn Wallwork

    Exclude last year from % difference to previous year calculation

    Grit Gehrmann

      I'm showing a booking trend and the % difference of bookings from the previous year on a dual axis chart. Please see the attached screenshot.

       

      Due to the fact that our current Fiscal year is still ongoing I want to exclude the % difference calculation from 2012 to 2013 (here -55,1%) from the chart but the total booking bar for 2013 should stay. How can I do this?

       

      Thanks for any idea!

      GritGrowth Trend.bmp