9 Replies Latest reply on Aug 25, 2017 12:10 PM by Pahola Diaz

    Sum of an aggregate field

    Pahola Diaz

      Hello everyone

       

      I'm working in RRHH data for global absenteeism rate and i did few table calculations on measures to get the sum of TGA by City

       

      17,39% is the Columns Grand Totals by default in Tableau ussing "Sum"

      TGA is a Calculated Field and i can´t aggregate it again

      TGA = (SUM([Horas_Ausentismo])/(AVG([Total Empleados])*SUM([Jornada Laboral ]))) where Jornada Laboral is an LOD expression

       

       

      What can i do to create a field which result in 17,39%?