Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting of Pivot Table Field | Excel Discussion (Misc queries) | |||
How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
Field Source Error for Pivot Table | Excel Worksheet Functions | |||
Group Field in Pivot Table €“ Not Enough Room | Excel Discussion (Misc queries) | |||
Creating Calculations Within a Pivot Table Field | Excel Discussion (Misc queries) |