1 Reply Latest reply on Sep 15, 2016 5:56 PM by Santiago Sanchez

    Average Sales per Headcount based on Period Selections

    VICTOR SALDAJENO

      Hello Tableau Community!

       

      Tableau beginner here, and enjoying learning the tool and its capabilities.

      I'm trying to come up with an average over period selections however not sure how to deal with it.

      The report comes out okay on individual months however becomes off on increased number of periods.

      Note:

           Periods are in text form (how all four data sources are glued to each other)

       

      Attached are pictures for Periods:

      201301

      201302

      201301 and 201302 combined

       

      201301

           Total Headcount:     45

           Net Sales:               $5,458,563

           Sales per HC:          $121,301

       

      201302

           Total Headcount:     46

           Net Sales:               $6,610,378

           Sales per HC:          $143,704

       

      201301 and 201302 per current calc

           Total Headcount:     91

           Net Sales:               $12,068,940

           Sales per HC:          $132,626

       

      201301 and 201302 target

           Total Headcount:     46 (45.50 average)

           Net Sales:               $12,068,940 (total)

           Sales per HC:          $132,503 (average per hc)

       

       

      Appreciate all the help.

       

      Thanks

      Victor