2 Replies Latest reply on Sep 4, 2017 3:35 AM by manh huy nguyen

    Simple VLOOKUP and SUMIFS (Excel functions) to do in Tableau

    manh huy nguyen

      Dear Communauty,

       

      After reading all VLOOKUP threads in the forum.. none of them could answer my simple question.

      How to perfom a simple VLOOKUP or SUMIFS function as in Excel ?

       

      Please see my Excel workbook attached (TEST.xlsx)

      Input:

        - Sheet Regions: List of all regions

        - Sheet Products: List of all products

        - Sheet Sales: Sales results

      Ouput:

        - Sheet Output: What a would like to have in tableau

       

      This request is different from my previous post but is part of the same project I have to work on:

      https://community.tableau.com/message/658724#658724

       

      Could you please try to create a .twbx file for me with this simple request?

      Thank you for your help.

       

      *******************************************************************************************************

      EDIT 1: I finally found out a temporary solution with jointures. See attachment (Book1.twbx).

      I am just afraid that in terms of performance, this is not the best solution as :

      - my real data set (Sales) contains thousands records)

      - i will have to add new filters (thus new sheets) that will multiply significantly all my Sales records..

      Would you have any other alternatives, please share.

       

       

      EDIT 2: Now, I'm facing another issue..

      My real project: Regions and Products are in an Excel sheet. Sales are stored in an Access table.

      When I import the Excel and Acces as data sources, there is NO WAY to create a Full Outer join between the 2 Excel sheets (between Regions and Products) !!

       

      Manh

      Tableau Desktop 10.3.1