7 Replies Latest reply: Dec 8, 2011 5:00 AM by Sushil Kumar RSS

    need help to calculate an expression??

    Sushil Kumar

      Hi All,

       

      I have a pivot table in which i have calculated dimensions as

       

      =aggr(sum({<test_fail_fdat.TT_TYPE=>}test_fail_fdat.TOTAL_FAILURES),test_fail_fdat.TT_TYPE)&'/'    for FAILURE

       

      and

       

      =aggr(sum(TOTAL_UNITS_PROCESSED),LOCATION_DESCR,OT_TYPE)   for TESTED

       

       

      I need to calculate yeild % and that should be ( Failure/Tested )* 100 and it  should  be shown  before  test  field

       

      How can i calculate this in pivot table...

       

      Please find the attached xl file which is exported from pivot table and application ..

       

      untitled.JPG

       

      Thanks

      Sushil