View Single Post
  #1   Report Post  
Dave
 
Posts: n/a
Default Pivot formatting

Hello. I would welcome someone's help on the following. I have a Pivot table
which looks like the following:

Region SalesPerson Sales
East Dave $100
Pete $200
Mike $240

I want the table to not leave the blanks on the left hand side. I want it
to look like the following:

Region SalesPerson Sales
East Dave $100
East Pete $200
East Mike $240

I am then using this data to create another table. The blanks revent me
from doing so. Does anyone know how to prevent the Pivot table from doing
this?

Thank you very much in advance.

--
DM