show detail in pivot table
 

Hi

my pivot is set up like this

code product qty
0204 a 30
b 35
0205 a 30
b 35

I would like it to read
code product qty
0204 a 30
0204 b 35
0205 a 30
0205 b 35

help please

You could use this formula in column D:
=IF(ISBLANK(A5),A4,A5)

You can't do what you want to do, in the Pivottable.

Ola


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378947

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat.

To create the table with a heading on each row, you can copy the table,
paste it as values in another location, and fill the blanks:

http://www.contextures.com/xlDataEntry02.html


robbie wrote:
Hi

my pivot is set up like this

code product qty
0204 a 30
b 35
0205 a 30
b 35

I would like it to read
code product qty
0204 a 30
0204 b 35
0205 a 30
0205 b 35

help please





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

thank you for clearing that up, I have managed to force a duplication through
using an autonumber for each entry,

cheers
Robbie


"olasa" wrote:


You could use this formula in column D:
=IF(ISBLANK(A5),A4,A5)

You can't do what you want to do, in the Pivottable.

Ola


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378947

if i copy and paste values for my pivot table is there an easy way to fill in
the blanks - my list is 10000 rows and it would take hours to fill in manually

"olasa" wrote:


You could use this formula in column D:
=IF(ISBLANK(A5),A4,A5)

You can't do what you want to do, in the Pivottable.

Ola


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378947

I think Debra's homepages explains it well.

Anyhow, do this:
1. Copy the Pivottable and Past it as Values.
2. Put the cursor in the first blank cell, and write ='the cell above'.
I.e. if you put the cursor in A2, write =A1.
3. Copy the formula you just wrote
4. Then select the area with the blanks. Press Ctrl+G, click Special...
and select Blanks
5. Select from the menu: EditPaste Special... Paste: Values

Done!

Hope it helped
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378947