1 Reply Latest reply: Jan 20, 2013 8:24 AM by schoupperudi RSS

    pivot table total count 0 & expression issue

      Hey Guys,

       

      Have following issues in my pivot table

       

      SHIFTSTART SHIFTEND SHIFTDATE SHIFTWEIGHT HANDLEDQTYPARTNO
      S114:0021:4514/01/201312515CRATE
      10010CASES
      505CASES
      TOTAL00

       

      Total gives my 0 ?? Any clues ?

       

      SHIFTSTART SHIFTEND SHIFTDATE SHIFTTOOLWEIGHT HANDLEDQTYPARTNO
      S114:0021:4514/01/2013CRANE112515CRATE
      10010CASES
      505CASES
      CRANE 212515CRATE
      10010CASES
      505CASES

       

      I inserted a new field tool but only want to have the view as below

       

      SHIFTSTART SHIFTEND SHIFTDATE SHIFTTOOLWEIGHT HANDLEDQTYPARTNO
      S114:0021:4514/01/2013CRANE112515CRATE
      CRANE210010CASES
      505CASES

       

      Thanks for helping me out with these issues