2 Replies Latest reply: Sep 13, 2013 9:07 AM by Cosmin Cirnu RSS

    pivot table with values variable for each item

    Cosmin Cirnu

      hi all

      i have a main source in which i have something like this:


      salesman     product               value

      john              product1              20

      adrian           product1              30

      mary             product1             40

      john              product2             25

      adrian           product2             35

      mary             product2             45


      and another source in which i linked salesman with a corespondent type of product



      salesman       vproduct

      john               product1

      adrian            product2

      mary              product2


      and i want to create a pivot table with all salesmen on rows and with an expression like a sum of value but just for products from the second source for each salesman (like a vlookup in excel)


      the result is like this:


      salesman    value

      john             20

      adrian          35

      mary           45


      thanks a lot!