2 Replies Latest reply on May 11, 2012 3:33 AM by Grzegorz Mikulski

    Joining data from two worksheets on one Dashboard

    Grzegorz Mikulski

      Dear Community,


      I'm new to Tableu so I was hoping that you could lend me a hand.


      My database is Excel based - I used pivots and Powerpoint/ThinkCell to create dashboards. Now I'm buildung my first dashboard in Tableu and cannot find an answer in Manual...


      Anyway, I managed to extract the data I needed in two separate worksheets. In Excel I have a column PeriodCd that indicates A (Actuals) or B (Budget).


      For first worksheet I filter PeriodCd (only A) to get Average FTE (running) and FTE (as I filtered A this is Actual FTE).


      In Second worksheet I have FTE (Actual - Budget) - so PeriodCd is no longer a filter, but presented in columns.


      D3 FTE Domain per agency.png

      Anyway - I'd like to present the two above tables (dashboard) as one table... Is there a way to join two together? Or present next to each other and hide columns I marked in red?


      Or maybe I do not need two worksheets to calculate this after all?


      I guess for some of you this might be a trivial question, but please let me know what are my options.


      Thanks and regards,