5 Replies Latest reply: Sep 8, 2015 5:40 AM by PAUL YEO RSS

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

    PAUL YEO

      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

      Sum($(Var))

      So the Diamension is  below :-

      Pick(Match($(Var),1,2,3),sales,cost,profit_amount)

      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 :-

      Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

      Sum({<nET_PROFIT={"nET_PROFIT"}>}Amount)/1000

      I try below :-

      Pick(Match($(Var),1,2,3,4),rEVENUE,nET_PROFIT)

      But it does not work.

       

       

      Enclsoed my QVF.

       

       

      Paul