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

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: Edit>Paste Special... Paste: Values

Done!

Hope it helped
Ola Sandström