1 Reply Latest reply on Dec 19, 2016 3:37 PM by Allison Bockman

    Displaying total % on Title

    J Jack

      Hello All,

       

      Need your help on below issue,

       

      I am comparing sales and target on bar chart, (sales on bar and reference line as target). When hover on the graph it show the sales, target, $ diff and % of Sale reached in achieving target for a particular item. I am able to show the sum of total sales and sum of Target sales

      on Title, but when try to put Total %, I am getting range. I have added the columns total on Top, if hover on it, it shows Sales, target, $ diff and % diff, this % diff (which is 87.58%) I want that on Title along with total sales and total target, but it is giving me range like 87.58% to 465.72%.

       

      Attaching workbook for reference.

       

      Thanks
      J