5 Replies Latest reply on Dec 23, 2015 6:15 AM by kumar.pediredla

    Need help with calculations

    kumar.pediredla

      Hi,

       

      I am a new to Tableau.  Need some help with calculations.  I need to calculate (%Diff from Tier Average) which is calculated as (Average Hourly Rate) at detail level divided by Grand Total (Average of "Avg Hrly Rate") and the result is subtracted by 1.  The calculation is done at detail level for each row.  Any suggestions or pointers are greatly appreciated.

       

      (%Diff from Tier Average) = ((Avg Hrly Rate)/ (Average of "Avg Hrly Rate")) - 1

       

       

      Data Source - MS Access

      Tableau 9.1

       

      Thanks,

      Kumar.

       

      Message was edited by: Kumar Pediredla