5 Replies Latest reply: Sep 8, 2015 5:40 AM by Yeo Poh sai RSS

    QS How to combine 2 Revenue and Net Profit Table into 1 Table ?

    Yeo Poh sai

      Hi All

      I have learn last few day on below, on how to make 1 chart display sales , cost , profit_amount  :-

      when i have expression = sum(sales) , using Pick(Match


      So the Diamension is  below :-


      Above are working fine.



      Now I wish to apply above for  combine Table 1 Reveune and Table 2 Net Profit  into One Table which display Revenue and Net Profit.



      Now i have new expression , which is more complicated , to replace with Pick ( Match :-



      I try below :-


      But it does not work.



      Enclsoed my QVF.