14 Replies Latest reply: Jul 28, 2015 8:26 PM by Mark Graham RSS

    Pick and Match

    Mark Graham

      Hi,

       

      I have a requirement which is as follows:

       

      I have Warehouse, ID, Units

       

      Where Warehouse comes from Table1 and ID and Units were from Table2.

       

      When i select Warehouse from Table1, Count(Distinct(ID) from Table 2and Sum(Units) from Table2 should be displaye d in table.

       

      =Pick(Match([W1], 'ABC'), Sum(TOTAL{<W2= {'ABC'}>} [Units]))

       

      =Pick(Match([W1], 'ABC'), Count(Distinct{<W2= {'ABC'}>} ID))


      The above coed is not giving me right answer...

      Can anyone look into this.