5 Replies Latest reply on May 25, 2018 1:09 AM by Patti P

    Year over Year calculation

    Patti P

      ** really appreciate any input, even if it points me to a thread I may have missed**

       

      Hi everyone,

       

      I have been searching the forums high and low to solve my particular challenge, I have found some solutions but they don't quite address what I'm trying to do. Here it goes and I hope you can help me out.

       

      I have a data set that spans from  Jan 2016 to April 2018 with data being added monthly to track.

       

      I need to enable the users to compare the year over year growth/loss for the selected month, quarter or year across this time.  I was able to use the YoY growth quick table calculation which accomplishes everything I need EXCEPT for  hiding the empty column (see picture) without it being hidden globally, I think the picture might be able to present what I'm talking about better.

       

      ALSO: This should be drillable with various dimensions (i.e. location, department, individual representative, etc)

      2018-05-10_10-38-04.jpg

       

      Appreciate your help on this