I would like to enter data (numbers) into a table with rows by date and columns as categories of activities. And then in a pivot table reverse the rows & columns so that dates are columns and activities are rows.

I wish to have both Row and Column totals in the pivot table but so far it displays row totals but not column totals.

I would also like to filter the dates and again am not sure how to do that in this pivot table.

The attached file has the a tab with the data table and a separate tab with the pivot table.

Attached Files

Pivot Test.xlsx (20.9 KB, 3 views)