PivotTable

[dennisli]

Good afternoon,
In the Row Labels of PivotTable, if there are two criteria, Month (as the first criteria) and Saleperson (as the second criteria), the default is put these two criteria in column A. Under each month, there are names of SalesPerson.
How can I put month in column A and Name of SalesPerson in column B?
Thanks
Dennis

 

[cyrilbrd]

Hi,

not sure if I understood correctly. why not dragging up the field of your choice during the creation of the pivot? Thus would reorganize the pivot to fit your needs...