Pivot Sum at every change in price

[Sanjeev1976]

Please help me with the subject query based on below data

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Month	Product	Qty	Price1	Price2	Price3	Value1	Value2	Value3
2	Jan-15	A	11	582.50	555.64	580.00	6,407.50	6,112.04	6,380.00		Row Labels	Sum of Qty	Sum of Value1	Sum of Value2	Sum of Value3
3	Jan-15	B	2	559.00	546.18	580.00	1,118.00	1,092.36	1,160.00		Jan-15	2,770	1,324,918	1,335,736	1,438,826
4	Jan-15	C	10	682.00	653.03	580.00	6,820.00	6,530.30	5,800.00		A	11	6,408	6,112	6,380
5	Jan-15	D	36	650.50	628.03	652.50	23,418.00	22,609.08	23,490.00		B	342	199,051	190,390	210,860
6	Jan-15	E	8	371.00	363.03	405.00	2,968.00	2,904.24	3,240.00		C	40	27,280	26,121	23,200
7	Jan-15	F	6	296.50	333.03	392.50	1,779.00	1,998.18	2,355.00		D	395	256,948	250,543	276,200
8	Jan-15	B	14	582.50	553.03	580.00	8,155.00	7,742.42	8,120.00		E	82	30,422	30,227	33,710
9	Jan-15	G	19	505.92	503.03	487.00	9,612.48	9,557.57	9,253.00		F	887	262,996	296,100	290,773
10	Jan-15	H	4	582.50	553.03	580.00	2,330.00	2,212.12	2,320.00		G	633	320,247	324,212	360,271
11	Jan-15	H	16	582.50	555.64	580.00	9,320.00	8,890.24	9,280.00		H	102	59,415	56,665	64,160
12	Jan-15	G	19	505.92	503.03	487.00	9,612.48	9,557.57	9,253.00		I	255	148,209	141,696	160,400
13	Jan-15	B	20	582.50	553.03	580.00	11,650.00	11,060.60	11,600.00		J	14	9,408	9,142	8,120
14	Jan-15	I	1	582.50	553.03	580.00	582.50	553.03	580.00		K	9	4,536	4,527	4,752
15	Jan-15	I	19	582.50	553.03	580.00	11,067.50	10,507.57	11,020.00		Feb-15	5,126	2,480,383	2,566,113	2,737,853
16	Jan-15	B	29	582.50	553.03	580.00	16,892.50	16,037.87	16,820.00		A	85	49,513	47,629	53,800
17	Jan-15	B	11	582.50	553.03	580.00	6,407.50	6,083.33	6,380.00		B	748	435,524	420,428	478,840
18	Jan-15	I	17	582.50	555.64	580.00	9,902.50	9,445.88	9,860.00		C	116	79,112	75,751	75,280
19	Jan-15	I	3	582.50	553.03	580.00	1,747.50	1,659.09	1,740.00		D	730	474,865	472,506	518,525
20	Jan-15	I	20	582.50	553.03	580.00	11,650.00	11,060.60	11,600.00		E	134	49,714	51,204	55,270
21	Jan-15	B	20	582.50	553.03	580.00	11,650.00	11,060.60	11,600.00		F	1,519	429,446	509,837	474,195
22	Jan-15	F	8	296.50	333.03	392.50	2,372.00	2,664.24	3,140.00		G	893	451,787	472,937	513,099
23	Jan-15	E	6	371.00	363.03	405.00	2,226.00	2,178.18	2,430.00		H	150	87,375	86,226	97,000
24	Jan-15	D	40	650.50	628.03	652.50	26,020.00	25,121.20	26,100.00		I	404	235,001	238,946	259,320
25	Jan-15	C	8	682.00	653.03	580.00	5,456.00	5,224.24	4,640.00		J	79	52,975	55,837	50,820
26	Jan-15	I	2	559.00	578.03	580.00	1,118.00	1,156.06	1,160.00		K	268	135,072	134,812	161,704
27	Jan-15	I	2	559.00	578.03	580.00	1,118.00	1,156.06	1,160.00		Grand Total	7,896	3,805,301	3,901,850	4,176,679
28	Jan-15	D	4	650.50	628.03	652.50	2,602.00	2,512.12	2,610.00
29	Jan-15	J	8	672.00	653.03	580.00	5,376.00	5,224.24	4,640.00
30	Jan-15	I	10	559.00	578.03	580.00	5,590.00	5,780.30	5,800.00
31	Jan-15	C	10	682.00	653.03	580.00	6,820.00	6,530.30	5,800.00
32	Jan-15	J	6	672.00	653.03	580.00	4,032.00	3,918.18	3,480.00
33	Jan-15	D	40	650.50	628.03	652.50	26,020.00	25,121.20	26,100.00
34	Jan-15	E	12	371.00	363.03	405.00	4,452.00	4,356.36	4,860.00
35	Jan-15	F	8	296.50	333.03	392.50	2,372.00	2,664.24	3,140.00
36	Jan-15	B	28	582.50	553.03	580.00	16,310.00	15,484.84	16,240.00
37	Jan-15	I	15	582.50	555.64	580.00	8,737.50	8,334.60	8,700.00
38	Jan-15	I	17	582.50	555.64	580.00	9,902.50	9,445.88	9,860.00
39	Jan-15	B	40	582.50	553.03	580.00	23,300.00	22,121.20	23,200.00
40	Jan-15	K	9	504.00	503.03	528.00	4,536.00	4,527.27	4,752.00
41	Jan-15	B	40	582.50	553.03	580.00	23,300.00	22,121.20	23,200.00
42	Jan-15	I	24	582.50	553.03	580.00	13,980.00	13,272.72	13,920.00
43	Jan-15	G	32	505.92	503.03	487.00	16,189.44	16,096.96	15,584.00
44	Jan-15	H	32	582.50	555.64	580.00	18,640.00	17,780.48	18,560.00
45	Jan-15	G	3	505.92	503.03	487.00	1,517.76	1,509.09	1,461.00
46	Jan-15	G	60	505.92	503.03	487.00	30,355.20	30,181.80	29,220.00
47	Jan-15	B	8	582.50	553.03	580.00	4,660.00	4,424.24	4,640.00
48	Jan-15	F	15	296.50	333.03	392.50	4,447.50	4,995.45	5,887.50
49	Jan-15	D	67	650.50	630.64	652.50	43,583.50	42,252.88	43,717.50
50	Jan-15	D	33	650.50	628.03	652.50	21,466.50	20,724.99	21,532.50
51	Jan-15	C	12	682.00	653.03	580.00	8,184.00	7,836.36	6,960.00
52	Jan-15	B	5	559.00	546.18	580.00	2,795.00	2,730.90	2,900.00
53	Jan-15	E	6	371.00	363.03	405.00	2,226.00	2,178.18	2,430.00
54	Jan-15	F	37	296.50	335.64	325.00	10,970.50	12,418.68	12,025.00
55	Jan-15	F	95	296.50	335.64	325.00	28,167.50	31,885.80	30,875.00
56	Jan-15	F	10	296.50	335.64	325.00	2,965.00	3,356.40	3,250.00
57	Jan-15	F	8	296.50	333.03	325.00	2,372.00	2,664.24	2,600.00
58	Jan-15	E	11	371.00	400.64	415.00	4,081.00	4,407.04	4,565.00
59	Jan-15	E	17	371.00	365.64	415.00	6,307.00	6,215.88	7,055.00
60	Jan-15	E	22	371.00	363.03	415.00	8,162.00	7,986.66	9,130.00
61	Jan-15	B	15	582.50	635.64	680.00	8,737.50	9,534.60	10,200.00
62	Jan-15	B	7	582.50	553.03	680.00	4,077.50	3,871.21	4,760.00
63	Jan-15	B	3	582.50	553.03	680.00	1,747.50	1,659.09	2,040.00
64	Jan-15	B	4	582.50	553.03	680.00	2,330.00	2,212.12	2,720.00
65	Jan-15	B	30	582.50	553.03	680.00	17,475.00	16,590.90	20,400.00
66	Jan-15	B	42	582.50	553.03	680.00	24,465.00	23,227.26	28,560.00
67	Jan-15	H	46	582.50	555.64	680.00	26,795.00	25,559.44	31,280.00
68	Jan-15	H	4	582.50	555.64	680.00	2,330.00	2,222.56	2,720.00
69	Jan-15	G	130	505.92	505.64	591.00	65,769.60	65,733.20	76,830.00
70	Jan-15	G	52	505.92	503.03	591.00	26,307.84	26,157.56	30,732.00
71	Jan-15	G	18	505.92	503.03	591.00	9,106.56	9,054.54	10,638.00
72	Jan-15	I	50	582.50	553.03	680.00	29,125.00	27,651.50	34,000.00
73	Jan-15	I	75	582.50	555.64	680.00	43,687.50	41,673.00	51,000.00
74	Jan-15	G	3	505.92	503.03	591.00	1,517.76	1,509.09	1,773.00
75	Jan-15	G	23	505.92	505.64	591.00	11,636.16	11,629.72	13,593.00
76	Jan-15	G	157	505.92	505.64	591.00	79,429.44	79,385.48	92,787.00
77	Jan-15	G	117	505.92	545.64	591.00	59,192.64	63,839.88	69,147.00
78	Jan-15	B	6	582.50	555.64	680.00	3,495.00	3,333.84	4,080.00
79	Jan-15	B	18	582.50	555.64	680.00	10,485.00	10,001.52	12,240.00
80	Jan-15	D	152	650.50	630.64	758.00	98,876.00	95,857.28	115,216.00
81	Jan-15	D	23	650.50	710.64	758.00	14,961.50	16,344.72	17,434.00
82	Jan-15	F	573	296.50	333.03	325.00	169,894.50	190,826.19	186,225.00
83	Jan-15	F	127	296.50	335.64	325.00	37,655.50	42,626.28	41,275.00
84	Feb-15	A	20	582.50	555.64	580.00	11,650.00	11,112.80	11,600.00
85	Feb-15	B	1	559.00	546.18	580.00	559.00	546.18	580.00
86	Feb-15	C	4	682.00	653.03	580.00	2,728.00	2,612.12	2,320.00
87	Feb-15	C	6	682.00	653.03	580.00	4,092.00	3,918.18	3,480.00
88	Feb-15	D	70	650.50	710.64	652.50	45,535.00	49,744.80	45,675.00
89	Feb-15	E	8	371.00	400.64	405.00	2,968.00	3,205.12	3,240.00
90	Feb-15	F	12	296.50	335.64	392.50	3,558.00	4,027.68	4,710.00
91	Feb-15	B	10	582.50	635.64	580.00	5,825.00	6,356.40	5,800.00
92	Feb-15	G	44	505.92	545.64	487.00	22,260.48	24,008.16	21,428.00
93	Feb-15	I	40	582.50	555.64	580.00	23,300.00	22,225.60	23,200.00
94	Feb-15	B	80	582.50	553.03	580.00	46,600.00	44,242.40	46,400.00
95	Feb-15	B	40	582.50	553.03	580.00	23,300.00	22,121.20	23,200.00
96	Feb-15	I	16	582.50	553.03	580.00	9,320.00	8,848.48	9,280.00
97	Feb-15	G	22	505.92	505.64	487.00	11,130.24	11,124.08	10,714.00
98	Feb-15	H	20	582.50	555.64	580.00	11,650.00	11,112.80	11,600.00
99	Feb-15	K	9	504.00	503.03	528.00	4,536.00	4,527.27	4,752.00
100	Feb-15	B	20	582.50	555.64	580.00	11,650.00	11,112.80	11,600.00
101	Feb-15	F	8	296.50	335.64	392.50	2,372.00	2,685.12	3,140.00
102	Feb-15	E	6	371.00	363.03	405.00	2,226.00	2,178.18	2,430.00
103	Feb-15	D	80	650.50	628.03	652.50	52,040.00	50,242.40	52,200.00
104	Feb-15	J	1	672.00	653.03	580.00	672.00	653.03	580.00
105	Feb-15	J	7	672.00	653.03	580.00	4,704.00	4,571.21	4,060.00
106	Feb-15	C	8	682.00	653.03	580.00	5,456.00	5,224.24	4,640.00
107	Feb-15	I	6	559.00	578.03	580.00	3,354.00	3,468.18	3,480.00
108	Feb-15	K	4	504.00	503.03	528.00	2,016.00	2,012.12	2,112.00
109	Feb-15	F	34	296.50	335.64	325.00	10,081.00	11,411.76	11,050.00
110	Feb-15	F	16	296.50	335.64	325.00	4,744.00	5,370.24	5,200.00
111	Feb-15	E	50	371.00	400.64	415.00	18,550.00	20,032.00	20,750.00
112	Feb-15	D	400	650.50	628.03	758.00	260,200.00	251,212.00	303,200.00
113	Feb-15	J	17	672.00	655.64	680.00	11,424.00	11,145.88	11,560.00
114	Feb-15	J	3	672.00	653.03	680.00	2,016.00	1,959.09	2,040.00
115	Feb-15	C	25	682.00	653.03	680.00	17,050.00	16,325.75	17,000.00
116	Feb-15	K	20	504.00	503.03	629.00	10,080.00	10,060.60	12,580.00
117	Feb-15	K	131	504.00	503.03	629.00	66,024.00	65,896.93	82,399.00
118	Feb-15	K	49	504.00	503.03	629.00	24,696.00	24,648.47	30,821.00
119	Feb-15	B	100	582.50	553.03	680.00	58,250.00	55,303.00	68,000.00
120	Feb-15	B	56	582.50	553.03	680.00	32,620.00	30,969.68	38,080.00
121	Feb-15	B	60	582.50	553.03	680.00	34,950.00	33,181.80	40,800.00
122	Feb-15	B	17	582.50	553.03	680.00	9,902.50	9,401.51	11,560.00
123	Feb-15	B	67	582.50	553.03	680.00	39,027.50	37,053.01	45,560.00
124	Feb-15	I	23	582.50	555.64	680.00	13,397.50	12,779.72	15,640.00
125	Feb-15	I	77	582.50	555.64	680.00	44,852.50	42,784.28	52,360.00
126	Feb-15	G	123	505.92	545.64	591.00	62,228.16	67,113.72	72,693.00
127	Feb-15	G	127	505.92	505.64	591.00	64,251.84	64,216.28	75,057.00
128	Feb-15	C	25	682.00	653.03	680.00	17,050.00	16,325.75	17,000.00
129	Feb-15	A	30	582.50	555.64	680.00	17,475.00	16,669.20	20,400.00
130	Feb-15	E	36	371.00	363.03	415.00	13,356.00	13,069.08	14,940.00
131	Feb-15	E	14	371.00	363.03	415.00	5,194.00	5,082.42	5,810.00
132	Feb-15	F	100	296.50	335.64	325.00	29,650.00	33,564.00	32,500.00
133	Feb-15	F	335	234.00	335.64	260.00	78,390.00	112,439.40	87,100.00
134	Feb-15	A	15	582.50	555.64	680.00	8,737.50	8,334.60	10,200.00
135	Feb-15	C	6	682.00	653.03	680.00	4,092.00	3,918.18	4,080.00
136	Feb-15	C	9	682.00	653.03	680.00	6,138.00	5,877.27	6,120.00
137	Feb-15	B	22	582.50	635.64	680.00	12,815.00	13,984.08	14,960.00
138	Feb-15	B	28	582.50	635.64	680.00	16,310.00	17,797.92	19,040.00
139	Feb-15	G	41	505.92	545.64	591.00	20,742.72	22,371.24	24,231.00
140	Feb-15	G	161	505.92	505.64	591.00	81,453.12	81,408.04	95,151.00
141	Feb-15	G	252	505.92	545.64	591.00	127,491.84	137,501.28	148,932.00
142	Feb-15	G	48	505.92	505.64	591.00	24,284.16	24,270.72	28,368.00
143	Feb-15	I	17	582.50	553.03	680.00	9,902.50	9,401.51	11,560.00
144	Feb-15	I	133	582.50	635.64	680.00	77,472.50	84,540.12	90,440.00
145	Feb-15	H	94	582.50	555.64	680.00	54,755.00	52,230.16	63,920.00
146	Feb-15	H	6	582.50	635.64	680.00	3,495.00	3,813.84	4,080.00
147	Feb-15	B	100	582.50	555.64	680.00	58,250.00	55,564.00	68,000.00
148	Feb-15	C	15	682.00	653.03	680.00	10,230.00	9,795.45	10,200.00
149	Feb-15	J	6	672.00	655.64	680.00	4,032.00	3,933.84	4,080.00
150	Feb-15	J	24	672.00	750.64	680.00	16,128.00	18,015.36	16,320.00
151	Feb-15	F	6	296.50	335.64	325.00	1,779.00	2,013.84	1,950.00
152	Feb-15	F	994	296.50	335.64	325.00	294,721.00	333,626.16	323,050.00
153	Feb-15	I	24	582.50	635.64	580.00	13,980.00	15,255.36	13,920.00
154	Feb-15	G	31	505.92	545.64	487.00	15,683.52	16,914.84	15,097.00
155	Feb-15	H	16	582.50	635.64	580.00	9,320.00	10,170.24	9,280.00
156	Feb-15	H	14	582.50	635.64	580.00	8,155.00	8,898.96	8,120.00
157	Feb-15	K	34	504.00	503.03	528.00	17,136.00	17,103.02	17,952.00
158	Feb-15	B	20	582.50	555.64	580.00	11,650.00	11,112.80	11,600.00
159	Feb-15	F	4	296.50	335.64	392.50	1,186.00	1,342.56	1,570.00
160	Feb-15	A	5	582.50	635.64	580.00	2,912.50	3,178.20	2,900.00
161	Feb-15	A	15	582.50	555.64	580.00	8,737.50	8,334.60	8,700.00
162	Feb-15	B	5	550.00	578.03	580.00	2,750.00	2,890.15	2,900.00
163	Feb-15	C	8	682.00	653.03	580.00	5,456.00	5,224.24	4,640.00
164	Feb-15	D	31	650.50	710.64	652.50	20,165.50	22,029.84	20,227.50
165	Feb-15	D	69	650.50	710.64	652.50	44,884.50	49,034.16	45,022.50
166	Feb-15	E	10	371.00	400.64	405.00	3,710.00	4,006.40	4,050.00
167	Feb-15	F	10	296.50	335.64	392.50	2,965.00	3,356.40	3,925.00
168	Feb-15	B	16	582.50	635.64	580.00	9,320.00	10,170.24	9,280.00
169	Feb-15	G	44	505.92	545.64	487.00	22,260.48	24,008.16	21,428.00
170	Feb-15	I	39	582.50	555.64	580.00	22,717.50	21,669.96	22,620.00
171	Feb-15	I	21	582.50	635.64	580.00	12,232.50	13,348.44	12,180.00
172	Feb-15	B	1	582.50	553.03	580.00	582.50	553.03	580.00
173	Feb-15	B	69	582.50	553.03	580.00	40,192.50	38,159.07	40,020.00
174	Feb-15	K	21	504.00	503.03	528.00	10,584.00	10,563.63	11,088.00
175	Feb-15	B	36	582.50	553.03	580.00	20,970.00	19,909.08	20,880.00
176	Feb-15	E	10	371.00	363.03	405.00	3,710.00	3,630.30	4,050.00
177	Feb-15	D	80	650.50	628.03	652.50	52,040.00	50,242.40	52,200.00
178	Feb-15	J	20	672.00	750.64	580.00	13,440.00	15,012.80	11,600.00
179	Feb-15	C	10	682.00	653.03	580.00	6,820.00	6,530.30	5,800.00
180	Feb-15	I	8	559.00	578.03	580.00	4,472.00	4,624.24	4,640.00
181	Feb-15	J	1	559.00	546.18	580.00	559.00	546.18	580.00
Sheet1

Cell Formulas
Range	Formula
G2:I181	G2	=$C2*D2

 

[Tivakaran]

The pivot table isnt automatically updated. Every time you change the price, right click on the pivot & click Refresh.