Crosstab in pivot table

[dcoons]

I have data like this:

office market sales revenue
one big 10 25
two little 5 50
three big 10 25

which needs to be summarized into markets. I can get the pivot table to "stack" the statistics:

Big sales 20
revenue 50
Little sales 5
revenue 50

But what I want is:
sales revenue
Big 20 50
Little 5 50

Can this be done in a pivot table, or do I need to use Access?

 

[GlennUK]

Pull the PivotTable data until it's the right shape

Pull the PivotTable data until it's the right shape, with your mouse. When tyhe icon for the data changes shape, drop it.

See here:

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	office	market	sales	revenue		market	Data	Total			Data
2	one	big	10	25		big	Sum of sales	20		market	Sum of sales	Sum of revenue
3	two	little	5	50			Sum of revenue	50		big	20	50
4	three	big	10	25		little	Sum of sales	5		little	5	50
5							Sum of revenue	50		Grand Total	25	100
6						Total Sum of sales		25
7						Total Sum of revenue		100
8
Sheet1

 

[Andrew Poulsom]

Move your mouse over the Data button until the cursor changes to a cross with arrows on the end. Then click and drag to the right.