2 Replies Latest reply on Oct 3, 2016 7:21 AM by Ashok Bhatta

    Get a total amount from two different sheets

    Ashok Bhatta

      Hello Tableau Experts,


      I am having problem combining two values from two different sheets in a combined third sheet. Is it doable? For example: I am creating a financial dashboard and I have got a requirement to make a filter by Directors. Directors have their respective Projects and Cost Centers. However, the projects always do not hit the same cost center. In this case, I need to find the other projects hitting a director's cost center. I used a filter by Project to find all the dollar amounts for his projects. I used another filter (in another sheet) by CC and excluded all the projects that are already included in the 'Filter by Project' sheet. I got two different sheets for the total amount and I want to combine these numbers for a total amount. Your help will be greatly appreciated. Thanks