3 Replies Latest reply: Jan 14, 2014 3:26 PM by Todd Demantes RSS

    Can I sum the columns in a pivot table

    Todd Demantes

      I have weekly sales numbers in a pivot table... how can I get a column to show the sales for the year? 

       

      Like for Kmart, 161,365+ 125,774+ 36,583 = 323,722

       

      the Show Partial Sums option sums the column, so I get a total for all 4 retailers summed by week, I want a total for each retailer for YTD.

       

      Untitled.png