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

    Pivot Table Totals - Incorrect

    Nayan Lalla

      Hi

       

      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

      Nayan

      pivot table.jpg