2 Replies Latest reply: Sep 15, 2015 5:18 AM by PAUL YEO RSS

    How to compute sum(sales) when user click on Diamension = Coy ?

    PAUL YEO

      Hi All

       

       

      I have Table 1 , it can display correct report when user click on Diamension = Brand , Product Class , Desc .

      But when user click on Diamension = Coy , Table 1 display wrong report.

       

       

      So when user click on Company , i want to table 2 data display at Table 1.

       

       

      I try the expression below :-

       

       

      if(

      $(ColumnDim10)

      ='5 COY'

      ,SUM(sales)

      ,SUM(C_ONHAND_AMT)

      ))

       

       

      it display null value.

       

       

      Paul