6 Replies Latest reply on Jun 15, 2016 10:40 AM by Dwight Taylor

    Adding Vertical Variance Columns with Measure Values in One Worksheet?

    Dwight Taylor

      Is it possible to create the following visualization using "ONE" Worksheet?  The image below is four different Worksheets (say it ain't so)..  The Workbook is attached

       

      V$ = Is the difference between 2016 and 2015

      V% = Is the % diff between 2016 and 2015

       

      The Desired View (visualization)

       

      The Current Single Worksheet View

      PLEASE NOTE: Please disregard the static formula on the Columns shelf, it's there simply to add a label to the column.

      Add Columns to Measure Names.png

       

      Message was edited by: Dwight Taylor Updated image