partial sum of a column, according to another column value...
 

Hi,

I've created a pivot table containing rows showing transactions spread
across a number of columns. Two of the columns are 'week #' and
'transaction'. Multiple transactions appear for each week #.

How can I sum the total number of tranactions for each of the week?

Many thanks in advance.