7 Replies Latest reply on Jun 27, 2018 6:39 AM by erik anderson

    Count X / Employee Count

    erik anderson

      [Edit: Added a dataset]

      I have two tables. One is detailed records (sales) and another is a summarized (employee count). The two are relateable by date (year) and geography. I am attempting to do a count of records per year / employee count per year and have the data roll-up and drill down.

       

      Example:

      The expected output would be:

      2016 Arizona = 4/100

      2016 California = 2/150

      2016 Total = 6/250

       

      How can I do this? I am thinking I need a staging table... but this seems like it is exactly the type of scenario that would be easy in Tableau.

       

      YearGeographyEmployeeCount
      2016Arizona100
      2016California150
      2017Arizona120

       

      TransactionGeographyDateInvoiceAmount
      123456Arizona1/2/2016100
      123457Arizona1/2/2016125
      123458California1/2/2016100
      123459Arizona1/2/2016100
      123460California1/2/201675
      123461Arizona1/3/2016

      125