2 Replies Latest reply on Jan 14, 2014 8:32 AM by alex macharia

    How to combine worksheet results onto one viz

    Ryan Johnson

      In the attached workbook, I have two worksheets that show what was paid to three companies.  I want to combine the two worksheets into one worksheet (or dashboard) so that Company A shows up for $278,119, Company B for $311,810, etc.  But I can't figure out how to do it because my filters to get my results are at odds: one sheet shows our EU division's projects (EU Partners) and the other (EU Subpartners) shows the US division's projects.  I was thinking that maybe some kind of dashboard could work as some previous posts seem to indicate that's a possibility.  I'm stuck.  Hopefully I'm over-thinking this.  Any ideas?

       

      Thanks,

      Ryan