1 Reply Latest reply on Feb 19, 2016 4:01 PM by Daniel Vincent

    Vlookup value in a second data source and use in calculation

    victor.novikov

      This is a dashboard for comparing one company performance against the whole industry.

      • I have a parameter field where dashboard user enters a name of a company
      • As a separate data source I have a table :
        • Company nameIndustry
          Company 1 Auto
          ......
          Company NCPG

       

      Is it possible to look up the industry value for the company in the second data source and based on that value choose what industry should it be compared against?

      So ideally the calculation would look something like this:

      1. look up to what industry this company belongs
      2. calculate industry performance

       

      in pseudo code :

      SUM ( IF industry = vlookup(company in company-industry table) then VALUE END )