ExcelAtEverything
Active Member
- Joined
- Jan 30, 2021
- Messages
- 351
- Office Version
- 2019
- Platform
- Windows
Hello Excel Jedi's!
I am using a Pivot Table and attempting to create Running Totals for each row. The problem is though, when I attempt to select a column header for "Running Totals In", there is only 1 option which is a row header (which incorrectly creates the running totals for columns instead of rows). Other times when I have successfully done this, the data for the Pivot Tables was always coming from the data model. This time however, the Pivot Table was created using data from a table located in a different sheet in the same workbook. Does anyone know of a solution for me?
Below is a pic of the Pivot Table, as well as a pic of the Table source.
I am using a Pivot Table and attempting to create Running Totals for each row. The problem is though, when I attempt to select a column header for "Running Totals In", there is only 1 option which is a row header (which incorrectly creates the running totals for columns instead of rows). Other times when I have successfully done this, the data for the Pivot Tables was always coming from the data model. This time however, the Pivot Table was created using data from a table located in a different sheet in the same workbook. Does anyone know of a solution for me?
Below is a pic of the Pivot Table, as well as a pic of the Table source.
