12 Replies Latest reply: Feb 14, 2012 12:46 PM by Mike Der RSS

    total (calculated summary) in pivot table

      Hi community,

       

      I'm trying to get a total column onto my pivot table to appear on the far right of the table.  I have attached a screen shot.  I can get totals on the top using partial sums but this is not what i'm trying to do. 

       

      In the attached image, you can see that the first row of data is for an address at "20 cherry treee sh ctr".  I want a total count of each SKU whether the value is greater than zero, and I want this as a column on the far right of the pivot table.  In the example for the first row of data the value should be 2.  For the second row of data it should be 5 (because 5 skus have a value greater than zero).

       

      Can anybody help me with this?

       

      thanks 

       

       

      pivot_tbl_total.jpg