#1
|
|||
|
|||
Row and Column Totals in Excel Pivot Table
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. |
Tags |
column totals, date filtering, pivot table |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot totals / subtotals | ProudLiberal | Excel | 0 | 03-20-2020 06:04 AM |
Pivot table- % growth and difference between two items in same column by months | sarana | Excel | 2 | 01-28-2019 06:42 AM |
Excel pivot table | Don Harrison | Excel | 6 | 06-07-2017 02:32 PM |
How do I get column titles to show up in my pivot table? | nrcahill | Excel | 3 | 03-07-2016 09:35 AM |
Pivot table with numbers as column headers | kezhia_0128 | Excel | 0 | 08-28-2014 12:48 PM |