Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table formatting
There are many times where I need to take Excel data and do a pivot table,
then do another pivot table from that data (summarize the data, and then do a pivot on the summarized data) Is there a way to do a pivot table where each repeat value prints? For example, if person 1 has 2 values, person 2 has 3 values, person 3 has 1 value, I would like to display: Person Value 1 1 1 2 2 1 2 2 2 3 3 1 Right now the data displays as: Person Value 1 1 2 2 1 2 3 3 1 -- David Ruderman Director of Marketing Chapman University |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table formatting
If you convert the pivottable to values
(select the whole thing edit|copy, edit|paste special|values) Then you can do whatever you want to the data. (You may want to do this to a copy of the pivottable so you can still use that pivottable.) Then you could use some techniques at Debra Dalgleish's site to fill those empty cells with the value above: http://www.contextures.com/xlDataEntry02.html David Ruderman - Chapman University wrote: There are many times where I need to take Excel data and do a pivot table, then do another pivot table from that data (summarize the data, and then do a pivot on the summarized data) Is there a way to do a pivot table where each repeat value prints? For example, if person 1 has 2 values, person 2 has 3 values, person 3 has 1 value, I would like to display: Person Value 1 1 1 2 2 1 2 2 2 3 3 1 Right now the data displays as: Person Value 1 1 2 2 1 2 3 3 1 -- David Ruderman Director of Marketing Chapman University -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table formatting
I was never aware that one could fill as you described. That's great to
know. I'll give it a try. So, there's no way to format pivot tables to repeat values? Any chance this will be in the next release? Thank you. -- David Ruderman Director of Marketing Chapman University "Dave Peterson" wrote: If you convert the pivottable to values (select the whole thing edit|copy, edit|paste special|values) Then you can do whatever you want to the data. (You may want to do this to a copy of the pivottable so you can still use that pivottable.) Then you could use some techniques at Debra Dalgleish's site to fill those empty cells with the value above: http://www.contextures.com/xlDataEntry02.html David Ruderman - Chapman University wrote: There are many times where I need to take Excel data and do a pivot table, then do another pivot table from that data (summarize the data, and then do a pivot on the summarized data) Is there a way to do a pivot table where each repeat value prints? For example, if person 1 has 2 values, person 2 has 3 values, person 3 has 1 value, I would like to display: Person Value 1 1 1 2 2 1 2 2 2 3 3 1 Right now the data displays as: Person Value 1 1 2 2 1 2 3 3 1 -- David Ruderman Director of Marketing Chapman University -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table formatting
There's no way that I've seen to fill those cells and keep the pivottable.
This is the best source I've seen for new stuff in the next version: http://blogs.msdn.com/excel/default.aspx David Ruderman - Chapman University wrote: I was never aware that one could fill as you described. That's great to know. I'll give it a try. So, there's no way to format pivot tables to repeat values? Any chance this will be in the next release? Thank you. -- David Ruderman Director of Marketing Chapman University "Dave Peterson" wrote: If you convert the pivottable to values (select the whole thing edit|copy, edit|paste special|values) Then you can do whatever you want to the data. (You may want to do this to a copy of the pivottable so you can still use that pivottable.) Then you could use some techniques at Debra Dalgleish's site to fill those empty cells with the value above: http://www.contextures.com/xlDataEntry02.html David Ruderman - Chapman University wrote: There are many times where I need to take Excel data and do a pivot table, then do another pivot table from that data (summarize the data, and then do a pivot on the summarized data) Is there a way to do a pivot table where each repeat value prints? For example, if person 1 has 2 values, person 2 has 3 values, person 3 has 1 value, I would like to display: Person Value 1 1 1 2 2 1 2 2 2 3 3 1 Right now the data displays as: Person Value 1 1 2 2 1 2 3 3 1 -- David Ruderman Director of Marketing Chapman University -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table formatting in office 2003 | Excel Discussion (Misc queries) | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) |