hi

When i use pivot table for below data; it shows country name once time
at first row only; i would like to show country name at each row; can
any body hlep me in this ; thanks & regards



Employee Name City Sales$ Country

A Lahore 1,000 Pakistan
B Karachi 2,000 Pakistan
C Islamabad 5,000 Pakistan
D Multan 8,000 Pakistan
E Faisalabad 3,000 Pakistan

Inside a "live" pivot table, no. But on a copy of the pivot (pasted special
as values), to populate it down, you could try the methods described in
either of these 2 excellent pages by:

1. Debra Dalgleish:
http://www.contextures.com/xlDataEntry02.html
Excel -- Data Entry -- Fill Blank Cells

Fill Blank Cells
Fill Blank Cells Programmatically**
**Sub FillColBlanks() by Dave Peterson

2. David McRitchie:
http://www.mvps.org/dmcritchie/excel/fillempt.htm
Fill in the Empty Cells

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SG" wrote:
hi

When i use pivot table for below data; it shows country name once time
at first row only; i would like to show country name at each row; can
any body hlep me in this ; thanks & regards



Employee Name City Sales$ Country

A Lahore 1,000 Pakistan
B Karachi 2,000 Pakistan
C Islamabad 5,000 Pakistan
D Multan 8,000 Pakistan
E Faisalabad 3,000 Pakistan