7 Replies Latest reply: Sep 23, 2011 4:03 AM by Sunil Chauhan RSS

    need help in expression calculation..

    Sushil Kumar

      Hi All,

       

       

      I have a pivot table in which i have to calculate a logic/expression as dimension for %NDFNDR column.. the logic is given below...

       

      the expression is aggregated over test type and measurement type (TT_TYPE,MT_TYPE)

       

      =aggr((Sum(NDFNDR_SUMMARY.TOTAL_FAILURES)/Sum(PRD_OP_DEFECT_YIELD_SUMMARY.TOTAL_DEFECTS)*100),NDFNDR_SUMMARY.TT_TYPE,NDFNDR_SUMMARY.MT_TYPE,

       

      now the problem is:

       

      Sum(PRD_OP_DEFECT_YIELD_SUMMARY.TOTAL_DEFECTS) should not be aggregated over TT_TYPE and MT_TYPE. or other ways TT_TYPE and MT_TYPE should not affect the Sum(PRD_OP_DEFECT_YIELD_SUMMARY.TOTAL_DEFECTS) caculation....

       

      test.JPG

       

      Please help me out,, how to solve this problem...

       

      Thanks in advance..