6 Replies Latest reply on May 4, 2018 1:46 AM by Ed Yeldham

    Year on Year blank column and coloured by issue

    Ed Yeldham

      Hello,

       

      Probably a very simple issue but one I am struggling with.

       

      I have basic sales data which the user can select 2 months from a filter to compare as the screen shot below.  I have then used a quick table calc to determine the difference in margin % and margin value in the 2 months.  In the first month as no difference exists (ie first month) it shows blank columns.  how do I remove these as when I try to hide it hides the data in the second month which I want to keep.

       

      Second issue is I put the difference on colour so I could highlight the ups and downs easily.  I used a 3 step colour of green and red centred on 0.  This works OK for my second month but the first month then renders in a lighter grey so is much harder to read.

       

      Help