1 Reply Latest reply on Mar 28, 2012 12:56 PM by Alex Kerin

    Displaying a Multi-Dimension/Measure Table Correctly

    gall3on

      I have an excel table that's being used in as a dashboard summary area.  I'm trying to figure out how to display the data in Tableau in the same manner but I'm stumped.

      Mar-12BudgetTo DateMonth EndEOM VarianceVariance %
      Revenue$50,000.00 $42,000.00 $51,900.00 $1,900.00 4%
      Spend$18,000.00 $17,000.00 $19,800.00 $1,800.00 10%
      Gross Profit$32,000.00 $25,000.00 $32,100.00 $100.00 0%
      Gross Margin %64%60%62%-2%-3%
      Sales635590660$25.00 4%
      Cost Per Sale$28.35 $28.81 $30.00 $1.65 6%

      How can I replicate this view? I'm thinking of creating a single Dimension field containing Budget, To Date, and Month End values, but the EOM Variance and Variance % should be done as calculations, right?