PivotTable Grand Total Error using Calculated Field
I've created the following Calculated Field formula in my PivotTable to
capture the number of events that were late. DaysLate is the difference between the target completion date and the actual date completed. =IF('DaysLate'1,1,0) The formula works great and places a 1 where appropriate. However, the Grand Total is incorrect in that is always displays 1 also instead of totaling the column. Any ideas? |
PivotTable Grand Total Error using Calculated Field
The grand total and subtotals for a calculated field will use the same
calculation as the other rows, instead of summarizing the data. As a workaround, you could calculate the total events late outside of the pivot table. Or, add a field to the source data, to calculate if the event was late. Then, add that field to the pivot table. CherylS wrote: I've created the following Calculated Field formula in my PivotTable to capture the number of events that were late. DaysLate is the difference between the target completion date and the actual date completed. =IF('DaysLate'1,1,0) The formula works great and places a 1 where appropriate. However, the Grand Total is incorrect in that is always displays 1 also instead of totaling the column. Any ideas? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com