MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pivot table


Posted by Riky on June 13, 2001 11:15 AM

I have a spreadsheet containing columns : companyname, region, purchase volume and sales volume. I am trying to get the sub total of purchase volume and sales volume by company by region. My problem is how do you make the purchase volume and sales volume sub total side by side instead of on under the other or creating 2 pivot tables.


Posted by Lars on June 13, 2001 11:29 AM

Put company and region in the row field and purch vol and sales volume in the column field and purch and sales volume in the data area.

That should work for a side by side total

Posted by Riky on June 13, 2001 11:44 AM

I actually just figure it out myself, you need to go to "auto format" (you can find it in the pivot table toolbar). and select the format you want.