1 Reply Latest reply on Oct 31, 2016 5:16 AM by Luciano Vasconcelos

    Need help in Calculations

    Sanjeev Matte

      Hello Guys,

       

      I am new to Tableau. Please help me solving the below issue.

       

      I have a column Period in Columns shell and Period is having two values(Current Period and Prior Period). and the rows shell is having employee count and dependents count.

       



      Current Period
      Prior Period%Change
      Employees3871230(387-1230)/387
      Dependents208980(208-980)/208

       

      Formulas:

       

      (Current Period employees-Prior Period employees)/Current Period employees

      (Current Period Dependents-Prior Period Dependents)/Current Period dependents

       

       

      Thanks

      Sanjeev