display all row fields in pivot table

  • Thread starter Thread starter Elle Tee
  • Start date Start date
E

Elle Tee

I have a pivot table which groups my row fields and shows blank cells. I
want to show all field cells.

Basically, I have:

Sales Bob Client ABC Contract 1 Project 1
<blank> <blank> <blank> Project 2
<blank> <blank> Contract 2 Project 1
<blank> Client XYZ Contract 1 Project 1

I want to display as:
Sales Bob Client ABC Contract 1 Project 1
Sales Bob Client ABC Contract 1 Project 2
Sales Bob Client ABC Contract 2 Project 1
Sales Bob Client XYZ Contract 1 Project 1

Is this possible?
 
Meant...
=if(len(a2)<>0,a2,f1
Sorry!
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



Gary Brown said:
The only way I know to do that is to create formulas outside the Pivot table
that fill in the info using formulas like [assuming the formulas start in
column F]...
=if(len(a2)=0,a2,f1

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



Elle Tee said:
I have a pivot table which groups my row fields and shows blank cells. I
want to show all field cells.

Basically, I have:

Sales Bob Client ABC Contract 1 Project 1
<blank> <blank> <blank> Project 2
<blank> <blank> Contract 2 Project 1
<blank> Client XYZ Contract 1 Project 1

I want to display as:
Sales Bob Client ABC Contract 1 Project 1
Sales Bob Client ABC Contract 1 Project 2
Sales Bob Client ABC Contract 2 Project 1
Sales Bob Client XYZ Contract 1 Project 1

Is this possible?
Click to expand...
Click to expand...
 
Back
Top