6 Replies Latest reply on Jun 7, 2017 8:13 AM by Teresa Wright

    YOY Variance - How to exclude the prior year from the view?

    Teresa Wright

      Data is masked.  In the screen shot below, I have customers (filtered dimension) and two measures called Amount (one is a duplicate set to "percent difference").  I want to show my yearly totals and the YOY variance percent on a single worksheet.  Is there a way to exclude the 2016 column from the YOY display?  Even if I could change that one column header to white text, it would be an improvement.

       

      screenshot 1.jpg