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

    Pick and Match

    Mark Graham



      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.