Hi All,
I have a pivot table that has a row field for each vendor and a column field for each month (Jan, Feb & March). The pivot table is showing one row for the March total and a second row for the Jan & Feb totals:
Vendor......Jan.....Feb.....Mar
Smith.......................300
Smith.......100.....200........
What I really want to see is one line for each vendor. I've adjusted everything I can think of, sort orders, etc. to no avail.
Any suggestions?
Thanks in advance,
DavidH
I have a pivot table that has a row field for each vendor and a column field for each month (Jan, Feb & March). The pivot table is showing one row for the March total and a second row for the Jan & Feb totals:
Vendor......Jan.....Feb.....Mar
Smith.......................300
Smith.......100.....200........
What I really want to see is one line for each vendor. I've adjusted everything I can think of, sort orders, etc. to no avail.
Any suggestions?
Thanks in advance,
DavidH