Pivot Table formatting after refresh
I have a pivot table set up, and have selected "Preserve cell formatting on update" in PivotTable Option. However, when I select a different slicer or refresh the data, the cell formats change dramatically and seemingly randomly. I cannot get the table to save the cell format consistently. Extremely frustrating, and a seemingly known issue with no good fix. Help!!!
PivotTable : Unexpected behavior with 2 tables
Hi, The first picture shows the expected behavior of adding 'Product' and 'Revenue' to a pivot table. Now when i add the same fields but from 2 different tables linked with a relationship, the result is different (please see 2nd picture). Could somebody explain this weird behavior ? Thanks in advance PivotTable with 1 table PivotTable with 2 tables RelationshipUnable to edit calculate values in a PivotTable
I have a pivot table, created by my colleague; it includes calculated values, and I am unable to see its formulas. The following steps were taken: 1) select cell in the pivot table; 2) click "Fields, Items & Sets" ( "PivotTable Analysis" on the ribbon); 3) choose "Calculated Field." Here I expect to see existing calculating fields in the "Name" drop-down list. DD list is empty. As a workaround, I take a look at another excel-file with those values (excel-university.com/edit-pivottable-values) but faced the same problem.Excel Update Pivot Table Source Not Working
Folks, I'm adding Pivot table source update comment in case others have the same problem. Problem I created a pivot table whose source data changed because I added rows to the source. When I clicked on the Change Source Button to extend the pivot table source to the additional rows, the Change PivotTable Source window popped up, but Excel did not return to the source data tab with the current row and columns marked. Instead, it just remained on the Pivot table tab. When I manually entered the new table source rows and columns on the Change PivotTable Source form and clicked ok, Excel erased my Pivot table. Normal Operation Excel is supposed to take you to the source table tab with the current selection marked, where you can either mark the new source rows and columns with your mouse or manually enter the rows and columns. When you press Ok on the Change PivotTable Source pop-up, Excel is supposed to update your Pivot table with information from the new source rows and columns. Solution Navigate to the Excel Options’ Data tab and uncheck “Prefer the Excel Data Model when creating PivotTables, QueryTables and Data Conversions.” If you need to leave this option checked, be careful to uncheck Add this data to the Data Model on the Create PivotTable pop-up when creating a new Pivot table.
PivotTable - Calculated Field Subtotal
I inserted in a calculated field into a pivot table that multiplies 2 values (this field is titled "sum of Prod Routing Hrs" in the table (see screenshot) and the automatic subtotal on the date (in the row field) will also multiply the values instead of sum them like it does for the other values. Any ideas on how I can fix this? I have also included a screenshot of the calculated field.
Percentage calculation in pivot table for a growing time series
Howdy, I'm trying to create a pivot table showing percentage occupancy across a portfolio of residential properties. The viewer should have the ability to slice the data however they want. I'm unsure how to accomplish this. The basic idea and issues are as follows: Everyday we get an update on the occupancy across the portfolio Some of the properties were added over time so the total number of units has changed multiple times I want to create a pivot table and pivot chart that grow daily to accommodate the newly reported occupancy. The pivot chart and table should show occupancy percentage which are calculated by dividing the occupancy for the period by the number of units during the period. Since I can't add percentages, I'm struggling to figure out how to accomplish this. I want to eventually post the pivot chart with the slicing functionality to a sharepoint site Here is an example of the data. Everyday there will be another column added. Properties start showing occupancy from the day they are acquired. Thanks, elansr
