3 Replies Latest reply on Sep 13, 2016 4:57 AM by Enrico Stancanelli

    How to hide a column when showing percent difference

    leo.galvan

      I've replicated the problem I'm having in the attached workbook. I'm trying to show the percent difference among two months... In the example, I used November and December. The Percent Difference field is displaying two columns - one shows values for December (which is correct, since December would have the increases/decreases over November) and one shows all zeros for November (which is also correct since, relative to November, the change for November will always be 0%.)

       

      How do I either 1) Hide the November part of the Percent Difference column or 2) Hide November altogether, without affecting the table calculation? If this isnt possible, does anyone else have an idea how to go about getting the percent difference?