3 Replies Latest reply on Jun 18, 2018 7:05 AM by Joe Oppelt

    summarize across 2 worksheet

    kevin smith

      Hello Everyone,

       

      I want to create a summarized walk across report in Tableau using 2 excel files.

       

      Files:

      1. Movements

      2.Headcount

       

      I'm having a lot of trouble combining the 2 files to make it work.

      any suggestions would be great.

       

      I've attached a small sample workbook in version 10.2.2 any different version I can't open. Thanks.

       

      desired result

       

       

      CensusJanFebMarAprMay
      Beginning HC1011121314
      Hires11111
      Transfers IN11111
      Gross In22222
      Loss-1-1-1-1-1
      Transfers Out
      Gross Out-1-1-1-1-1
      Endning HC1112131415