display all row fields in pivot table


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?
 
Ad

Advertisements

G

Gary Brown

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top