2 Replies Latest reply on Jul 20, 2016 6:33 AM by Cindy Winegarden

    Grand total percent variance as reference line

    Cindy Winegarden

      Hi.

       

      The attached workbook is done using Beta 10.0.0 (10000.16.0618.1635)

      Sheet "Tabular" shows the values for each row and the bottom line. Note that the bottom line of the Current % Variance column is 19.4%.

      Sheet "Show dept variance is 19.4%" shows the percent variance for each row. You can see it better with the "Remove 2S to see it better" sheet, but that doesn't include line 2S, which needs to be included in the total.

       

      On the "Show dept variance is 19.4%" sheet, how can I show a line from top to bottom at 19.4%?

       

      Thanks for your help.