2 Replies Latest reply on Nov 22, 2016 12:12 PM by Brian Joubran

    Aligning Table Calculations Next to Dimensions

    Brian Joubran

      Hello,

       

      I'm trying to show Quarterly and Yearly % Change across products with measure values listed vertically. Would also like to add positive and negative colors/shapes. See example tables below.

       

      Essentially, the table calculations for the measures need to be adjacent to the dimensions rather than the measures.

       

      Example 1

      Product A

      (Dimension 1)

      Q/Q

      (Table Calc)

      Y/Y

      (Table Calc)

      Product B

      (Dimension 2)

      Q/Q

      (Table Calc)

      Y/Y

      (Table Calc)

      Revenues

      (Measure 1)

      $100,000 -10% 5%$500,000 -1.5% -3.5%

      Margin

      (Measure 2)

      5% 5% -3%8% 8% -3%

      Quantity Sold

      (Measure 3)

      50,000 2% 7%100,000 -5.5% 2.4%

       

      Or transposed as below:

       

      Example 2

      Revenues

      (Measure 1)

      Margin

      (Measure 2)

      Quantity Sold

      (Measure 3)

      Product A

      (Dimension 1)

      $100,000......

      Q/Q

      (Table Calc)

      -10%......

      Y/Y

      (Table Calc)

      5%......

      Product B

      (Dimension 2)

      $500,000......

      Q/Q

      (Table Calc)

      -1.5%......

      Y/Y

      (Table Calc)

      -3.5%......

       

      Many thanks for any input or insights!