how do I repeat field value in a pivot table?
In a pivot table, the value field is not repeated on each line. For further
investigation purpose (needing for example a sort on the field) I would like to have this value repeated on each line. How could I do this? |
how do I repeat field value in a pivot table?
It's not possible if you still want to keep it as a pivottable.
But you could copy it and paste special|values (to another location) and fill the empty cells using techniques from Debra Dalgleish's site: http://www.contextures.com/xlDataEntry02.html But this copy won't be a pivottable anymore. jvittone wrote: In a pivot table, the value field is not repeated on each line. For further investigation purpose (needing for example a sort on the field) I would like to have this value repeated on each line. How could I do this? -- Dave Peterson |
All times are GMT +1. The time now is 07:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com