4 Replies Latest reply: Sep 25, 2013 8:53 AM by Nayan Lalla RSS

    Pivot Table Totals - Incorrect



      I have a problem with totals on a pivot table. The total should show 10,000 , but appears blank.   Below is a screen shot of the pivot table.


      My formula is as follows for JHB - PO:


      if([Component Code] = [ITEM CODE], sum(TOTAL([Loc Qty on PO])))


      Under the total mode i've tried both Expression Total ans SUm, the result is still zero.


      Your help would be appreciated.


      kind regards


      pivot table.jpg