2 Replies Latest reply on Feb 8, 2019 1:40 AM by Mihai Constantinescu

    How to hide blank column when variance is calculated

    chandrakanth k

      Hello All,

       

      I have table where i have calculated % variance across table quarter wise. My variance is calculated relative to First column. I am able to get the right % but i see variance column even for my first selected quarter which dosent add any value. How do i hide the First selected quarter. Also I need help to change headers for Variance.

       

      For example when my first selected quarter is Q4 in Variance it shows Q2 and Q3 Variance but i want to change header to Q4 Vs Q2 and Q4 VS Q3.

       

       

      Regards,

      Chandrakanth.K