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


      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 )