Need Formula for Net Sales

[prashanthesky]

Dear Masters,

I have two Pivot Table one in Sales & second one is sales return know I need for formul for Net sales (Sales - Sales Return) & in Pivot Selecting Zone Wise below is the exaple Please if any formula for getting Net sales or in through pivot table it will be great for me.

Excel 2007
	A	B	C	D	E	F	G	H	I	J	K
1	Pivot Table - 1						Pivot Table - 2
2	Sales						Sales Return
3		Auroflex		Aurovue				Auroblue		Auroflex
4	Paty	Qty	Val	Qty	Val		Party	Qty	Val	Qty	Val
5	C A P PRABHU DR						ASHWIN NAYAK SUJIR DR. BC Road
6	GURURAJ. DR			123	3,500		C A P PRABHU DR	25	1,500	33	5500
7	HARIKRISHNA KAMAT DR	1	441				FR MULLERS HOSPITAL
8	KISHORE KRISHNA DR						GOVINDA RAJ P DR	30	1,860
9	KMC Hospital Stores MNG	4	2,800				GURURAJ. DR
10	J S S HOSPITAL						Harsha S Pai Dr M Lore
11	RAJESH NAYAK DR						J S S HOSPITAL
12	SRINATH KAMATH DR	1	420				JAYARAM SHETTY DR
13	Sripathi Kamath B Dr.						JUSTICE KS HEGDE CHARITABLE HOSPITAL
14	Grand Total	6	3,661	123	3,500		Grand Total	55	3,360	33	5,500
15
16
17	Net Sales
18	Paty	Qty	Val	Qty	Val
19
20
21
22
23
24
25
26
27
28	Grand Total
Net Sales

Cell Formulas
Range	Formula
A1	Pivot Table - 1
A2	Sales
A4	Paty
A5	C A P PRABHU DR
A6	GURURAJ. DR
A7	HARIKRISHNA KAMAT DR
A8	KISHORE KRISHNA DR
A9	KMC Hospital Stores MNG
A10	J S S HOSPITAL
A11	RAJESH NAYAK DR
A12	SRINATH KAMATH DR
A13	Sripathi Kamath B Dr.
A14	Grand Total
A17	Net Sales
A18	Paty
A28	Grand Total
G1	Pivot Table - 2
G2	Sales Return
G4	Party
G5	ASHWIN NAYAK SUJIR DR. BC Road
G6	C A P PRABHU DR
G7	FR MULLERS HOSPITAL
G8	GOVINDA RAJ P DR
G9	GURURAJ. DR
G10	Harsha S Pai Dr M Lore
G11	J S S HOSPITAL
G12	JAYARAM SHETTY DR
G13	JUSTICE KS HEGDE CHARITABLE HOSPITAL
G14	Grand Total
B3	Auroflex
B4	Qty
B7	1
B9	4
B12	1
B14	6
B18	Qty
D3	Aurovue
D4	Qty
D6	123
D14	123
D18	Qty
H3	Auroblue
H4	Qty
H6	25
H8	30
H14	55
J3	Auroflex
J4	Qty
J6	33
J14	33
C4	Val
C7	441
C9	2800
C12	420
C14	3661
C18	Val
E4	Val
E6	3500
E14	3500
E18	Val
I4	Val
I6	1500
I8	1860
I14	3360
K4	Val
K6	5500
K14	5500