VBA Help- Create Pivot exclude few Columns

[Mallesh23]

Hi Team,

Need your help to Create Pivot Table and it should Exclude 10-30 Bucket Column value.
Attached are sample input data and Below is expected Output.

In output i Dont want to show 10-30 Bucket Column. Expected >30days Columns.

and 0 value in blank space.

Overdue Payment_MRL_17.10.2020.xlsb
	I	J	K
1	Dummy Data
2	Region	Outstanding Amount	Ageing Bucket
3	West	1,418.34	>1 Year
4	North	14,307.02	>1 Year
5	West	97,405.99	>1 Year
6	West	4,638.94	121-365 Days
7	South	2,565.82	121-365 Days
8	West	112.25	121-365 Days
9	South	4,233.61	121-365 Days
10	South	2,138.18	91-120 Days
11	West	1,988.52	91-120 Days
12	South	2,138.18	91-120 Days
13	North	2,87,846.84	61-90 Days
14	South	55,592.87	61-90 Days
15	South	1,41,456.59	31-60 Days
16	South	67,288.82	31-60 Days
17	South	10,690.94	31-60 Days
18	South	2,12,585.51	31-60 Days
19	South	1,13,780.87	31-60 Days
20	South	1,32,455.98	31-60 Days
21	South	65,257.50	31-60 Days
22	South	4,58,147.91	31-60 Days
23	South	8,85,636.57	31-60 Days
24	South	16,089.88	31-60 Days
25	South	53,476.09	31-60 Days
26	South	26,764.22	31-60 Days
27	South	18,168.49	31-60 Days
28	South	7,668.52	31-60 Days
29	South	14,448.83	31-60 Days
30	South	34,866.60	31-60 Days
31	South	73,868.07	31-60 Days
32	South	30,485.25	31-60 Days
33	South	41,267.01	31-60 Days
34	South	2,54,678.01	31-60 Days
35	South	1,00,436.40	31-60 Days
36	South	5,419.34	31-60 Days
37	South	1,08,725.98	31-60 Days
38	West	21,606.40	31-60 Days
39	West	32,190.44	31-60 Days
40	West	1,165.32	31-60 Days
41	West	2,13,460.33	31-60 Days
42	West	13,230.00	31-60 Days
43	West	21,460.56	31-60 Days
44	South	25,850.68	31-60 Days
45	South	1,99,965.14	31-60 Days
46	South	13,186.38	31-60 Days
47	South	34,624.38	31-60 Days
48	West	4,32,043.66	31-60 Days
49	North	13,31,690.11	31-60 Days
50	North	3,14,506.05	31-60 Days
51	West	19,799.62	31-60 Days
52	South	35,194.57	31-60 Days
53	South	81,623.12	31-60 Days
54	South	3,964.55	31-60 Days
55	South	4,083.95	31-60 Days
56	North	3,271.43	31-60 Days
57	North	16,592.32	31-60 Days
58	North	6,90,558.40	31-60 Days
59	North	57,722.51	31-60 Days
60	South	8,809.33	31-60 Days
61	South	1,935.06	31-60 Days
62	South	27,090.83	31-60 Days
63	South	1,97,630.90	31-60 Days
64	South	5,901.40	31-60 Days
65	West	11,137.61	31-60 Days
66	West	12,581.98	31-60 Days
67	South	2,81,947.84	31-60 Days
68	South	50,811.05	31-60 Days
69	West	1,35,263.35	31-60 Days
70	West	63,883.48	31-60 Days
71	West	8,708.95	31-60 Days
72	South	8,580.56	31-60 Days
73	South	2,03,119.55	31-60 Days
74	South	791.72	31-60 Days
75	South	2,12,753.94	31-60 Days
76	South	4,60,884.81	31-60 Days
77	South	1,56,085.24	31-60 Days
78	South	957.56	31-60 Days
79	North	2,00,370.82	31-60 Days
80	South	2,94,815.38	31-60 Days
81	South	11,043.77	31-60 Days
82	South	26,758.09	31-60 Days
83	South	7,175.44	31-60 Days
84	North	5,976.56	31-60 Days
85	North	15,427.41	31-60 Days
86	North	17,474.16	31-60 Days
87	North	15,427.41	31-60 Days
88	North	6,619.96	31-60 Days
89	North	92,128.71	31-60 Days
90	North	27,116.96	31-60 Days
91	North	20,472.30	31-60 Days
92	South	97,221.52	31-60 Days
93	South	21,380.08	31-60 Days
94	South	8,919.01	31-60 Days
95	South	11,854.12	31-60 Days
96	South	3,487.53	31-60 Days
97	South	7,425.09	31-60 Days
98	South	45,919.60	31-60 Days
99	South	5,423.40	31-60 Days
100	South	64,246.88	31-60 Days
101	North	2,375.16	31-60 Days
102	North	2,375.16	31-60 Days
103	North	65,831.23	31-60 Days
104	North	1,15,465.93	31-60 Days
105	North	1,841.16	31-60 Days
106	North	10,057.03	31-60 Days
107	North	5,841.62	31-60 Days
108	North	12,507.08	31-60 Days
109	North	1,583.44	31-60 Days
110	North	15,299.51	31-60 Days
111	North	1,04,999.57	31-60 Days
112	South	46,854.14	31-60 Days
113	South	12,767.43	31-60 Days
114	South	1,990.01	31-60 Days
115	South	12,261.00	31-60 Days
116	South	8,180.15	31-60 Days
117	South	8,901.54	31-60 Days
118	South	1,226.81	31-60 Days
119	South	11,361.04	31-60 Days
120	South	9,992.84	31-60 Days
121	South	9,992.84	31-60 Days
122	South	1,983.77	31-60 Days
123	South	1,983.77	31-60 Days
124	West	33,744.16	31-60 Days
125	West	18,420.83	31-60 Days
126	East	2,22,302.31	31-60 Days
127	East	2,04,078.26	31-60 Days
128	East	82,595.95	31-60 Days
129	East	10,48,121.00	31-60 Days
130	East	2,19,652.24	31-60 Days
131	South	6,799.28	31-60 Days
132	South	4,505.28	31-60 Days
133	South	3,05,540.11	31-60 Days
134	South	36,592.82	31-60 Days
135	South	16,792.05	31-60 Days
136	South	24,560.32	31-60 Days
137	South	14,243.18	31-60 Days
138	South	3,14,059.28	31-60 Days
139	South	5,59,695.01	31-60 Days
140	South	40,293.49	31-60 Days
141	South	4,236.79	31-60 Days
142	South	9,576.88	31-60 Days
143	West	53,303.05	31-60 Days
144	West	10,805.94	31-60 Days
145	West	5,206.47	31-60 Days
146	West	11,137.63	31-60 Days
147	West	8,798.63	31-60 Days
148	West	11,135.55	31-60 Days
149	West	13,459.88	31-60 Days
150	West	1,45,527.76	31-60 Days
151	West	33,673.53	31-60 Days
152	West	9,824.45	31-60 Days
153	South	40,408.99	31-60 Days
154	South	9,824.45	31-60 Days
155	South	95,702.17	31-60 Days
156	South	25,987.77	31-60 Days
157	South	1,66,233.02	31-60 Days
158	South	38,101.55	31-60 Days
159	North	14,643.31	31-60 Days
160	North	59,220.04	31-60 Days
161	North	22,360.83	31-60 Days
162	North	86,106.55	31-60 Days
163	North	3,63,912.02	31-60 Days
164	North	9,576.88	31-60 Days
165	West	16,649.36	31-60 Days
166	West	2,482.17	31-60 Days
167	East	4,407.97	31-60 Days
168	East	6,90,969.56	31-60 Days
169	East	4,407.97	31-60 Days
170	East	1,390.85	31-60 Days
171	East	18,068.72	31-60 Days
172	South	20,898.61	31-60 Days
173	South	6,387.27	31-60 Days
174	South	22,332.30	31-60 Days
175	South	1,41,447.37	31-60 Days
176	South	3,166.01	31-60 Days
177	South	1,936.51	31-60 Days
178	South	7,23,127.37	31-60 Days
179	South	1,983.77	31-60 Days
180	South	3,193.64	31-60 Days
181	South	15,898.65	31-60 Days
182	West	53,816.43	31-60 Days
183	West	3,680.43	31-60 Days
184	West	3,680.43	31-60 Days
185	West	2,910.12	31-60 Days
186	West	7,360.88	31-60 Days
187	West	791.72	31-60 Days
188	West	5,542.05	31-60 Days
189	West	2,375.16	31-60 Days
190	West	3,166.89	31-60 Days
191	West	2,375.16	31-60 Days
192	West	1,66,480.76	31-60 Days
193	West	1,676.17	31-60 Days
194	West	7,125.50	31-60 Days
195	West	5,542.05	31-60 Days
196	South	1,21,483.79	31-60 Days
197	South	23,805.18	31-60 Days
198	South	1,936.51	31-60 Days
199	South	3,352.32	31-60 Days
200	South	15,085.53	31-60 Days
201	South	3,352.32	31-60 Days
202	North	4,386.55	31-60 Days
203	North	13,038.47	31-60 Days
204	North	2,482.16	31-60 Days
205	North	32,353.65	31-60 Days
206	North	5,82,982.21	31-60 Days
207	North	4,761.02	31-60 Days
208	North	3,156.19	31-60 Days
209	North	3,155.71	31-60 Days
210	East	50,148.53	31-60 Days
211	East	4,172.59	31-60 Days
212	East	87,243.38	31-60 Days
213	South	14,563.91	31-60 Days
214	South	1,74,608.18	31-60 Days
215	South	16,048.45	31-60 Days
216	South	19,390.71	31-60 Days
217	South	8,928.09	31-60 Days
218	South	86,395.17	31-60 Days
219	South	29,229.20	31-60 Days
220	South	79,986.50	31-60 Days
221	South	38,833.31	31-60 Days
222	South	1,03,799.48	31-60 Days
223	South	22,772.66	31-60 Days
224	South	56,169.54	31-60 Days
225	South	67,322.72	31-60 Days
226	South	52,861.75	31-60 Days
227	South	52,861.75	31-60 Days
228	South	2,44,026.19	31-60 Days
229	South	1,52,601.29	31-60 Days
230	South	1,05,747.94	31-60 Days
231	South	1,04,101.43	31-60 Days
232	South	1,02,345.42	31-60 Days
233	South	5,20,148.07	31-60 Days
234	South	2,08,529.99	31-60 Days
235	South	44,721.51	31-60 Days
236	South	4,653.72	31-60 Days
237	South	3,487.53	31-60 Days
238	South	4,236.79	31-60 Days
239	South	1,88,641.17	31-60 Days
240	South	2,67,197.65	31-60 Days
241	South	24,140.79	31-60 Days
242	South	1,29,168.12	31-60 Days
243	South	5,437.20	31-60 Days
244	South	22,681.79	31-60 Days
245	South	41,340.77	31-60 Days
246	South	25,677.51	31-60 Days
247	South	30,812.99	31-60 Days
248	South	3,973.78	31-60 Days
249	South	3,27,010.04	31-60 Days
250	South	9,201.11	31-60 Days
251	South	1,07,688.57	31-60 Days
252	South	52,724.45	31-60 Days
253	South	5,135.51	31-60 Days
254	South	21,890.07	31-60 Days
255	South	1,02,742.62	31-60 Days
256	South	1,32,525.86	31-60 Days
257	South	1,990.01	31-60 Days
258	South	3,967.52	31-60 Days
259	South	16,048.45	31-60 Days
260	South	46,647.45	31-60 Days
261	South	11,611.95	31-60 Days
262	South	9,686.13	31-60 Days
263	South	2,36,797.83	31-60 Days
264	South	35,109.69	31-60 Days
265	South	46,970.22	31-60 Days
266	South	43,932.60	31-60 Days
267	South	40,249.52	31-60 Days
268	South	7,161.16	31-60 Days
269	South	8,887.25	31-60 Days
270	South	4,722.52	31-60 Days
271	South	5,20,488.16	31-60 Days
272	South	2,24,492.66	31-60 Days
273	South	75,383.06	31-60 Days
274	South	9,479.29	31-60 Days
275	South	8,387.98	31-60 Days
276	South	29,653.60	31-60 Days
277	South	6,590.55	31-60 Days
278	South	92,052.61	31-60 Days
279	South	4,464.06	31-60 Days
280	South	2,91,180.97	31-60 Days
281	South	11,041.30	31-60 Days
282	South	3,680.43	31-60 Days
283	South	1,11,461.74	31-60 Days
284	South	83,879.83	31-60 Days
285	South	19,258.13	31-60 Days
286	North	1,91,021.49	16-30 Days
287	North	9,576.88	16-30 Days
288	North	55,600.95	16-30 Days
289	North	2,74,192.87	16-30 Days
290	North	5,97,001.81	16-30 Days
291	North	2,87,436.03	16-30 Days
292	North	5,670.46	16-30 Days
293	North	22,564.11	16-30 Days
294	North	1,13,582.59	16-30 Days
295	North	19,153.76	16-30 Days
296	North	58,309.32	16-30 Days
297	South	1,44,425.17	16-30 Days
298	South	14,563.91	16-30 Days
299	South	33,673.53	16-30 Days
300	South	8,387.98	16-30 Days
301	South	70,104.53	16-30 Days
302	North	66,247.94	16-30 Days
303	North	38,345.07	16-30 Days
304	North	4,793.11	16-30 Days
305	North	2,396.56	16-30 Days
306	North	3,680.43	16-30 Days
307	South	1,10,277.71	16-30 Days
308	South	30,085.46	16-30 Days
309	South	68,281.61	16-30 Days
310	South	2,17,113.92	16-30 Days
311	South	5,35,558.79	16-30 Days
312	West	32,868.56	16-30 Days
313	East	1,16,999.89	16-30 Days
314	East	50,174.20	16-30 Days
315	East	6,804.53	16-30 Days
316	East	26,347.61	16-30 Days
317	East	4,22,766.03	16-30 Days
318	East	46,310.30	16-30 Days
319	East	6,804.53	16-30 Days
320	East	85,388.40	16-30 Days
321	East	7,425.09	16-30 Days
322	East	12,581.98	16-30 Days
323	West	62,119.06	16-30 Days
324	West	3,423.67	16-30 Days
325	West	35,884.31	16-30 Days
326	West	46,647.45	16-30 Days
327	West	29,357.94	16-30 Days
328	West	7,425.09	16-30 Days
329	West	51,297.66	16-30 Days
330	West	2,332.38	16-30 Days
331	West	45,110.35	16-30 Days
332	West	29,935.67	16-30 Days
333	West	3,967.52	16-30 Days
334	East	5,54,167.58	16-30 Days
335	East	9,682.57	16-30 Days
336	East	41,711.66	16-30 Days
337	East	22,467.81	16-30 Days
338	East	1,74,949.34	16-30 Days
339	East	2,42,053.20	16-30 Days
340	West	1,65,706.19	16-30 Days
341	West	76,690.11	16-30 Days
342	West	6,419.38	16-30 Days
343	West	36,248.07	16-30 Days
344	West	16,861.54	16-30 Days
345	West	8,815.94	16-30 Days
346	West	49,594.13	16-30 Days
347	West	18,430.74	16-30 Days
348	West	26,362.24	16-30 Days
349	West	3,316.68	16-30 Days
350	West	3,193.64	16-30 Days
351	West	2,125.51	16-30 Days
352	North	3,19,789.93	16-30 Days
353	North	40,121.09	16-30 Days
354	North	9,576.88	16-30 Days
355	North	56,251.57	16-30 Days
356	North	29,691.35	16-30 Days
357	North	6,419.37	16-30 Days
358	North	1,77,271.02	16-30 Days
359	North	35,948.49	16-30 Days
360	North	88,672.98	16-30 Days
361	North	4,579.16	16-30 Days
362	North	2,89,032.79	16-30 Days
363	North	16,270.18	16-30 Days
364	North	1,67,314.64	16-30 Days
365	North	27,803.83	16-30 Days
366	North	16,134.04	16-30 Days
367	North	8,473.56	16-30 Days
368	West	16,857.99	16-30 Days
369	North	7,489.27	16-30 Days
370	North	20,242.43	16-30 Days
371	North	5,549.20	16-30 Days
372	North	12,881.53	16-30 Days
373	North	11,447.88	16-30 Days
374	North	4,750.33	16-30 Days
375	North	1,24,388.54	16-30 Days
376	North	32,353.65	16-30 Days
377	North	61,647.38	16-30 Days
378	North	21,569.09	16-30 Days
379	North	94,739.25	16-30 Days
380	North	24,179.62	16-30 Days
381	North	4,750.33	16-30 Days
382	West	14,202.52	16-30 Days
383	West	1,840.23	16-30 Days
384	West	1,198.30	16-30 Days
385	North	7,48,499.08	16-30 Days
386	North	90,101.84	16-30 Days
387	North	3,380.87	16-30 Days
388	North	3,73,886.50	16-30 Days
389	North	19,109.62	16-30 Days
390	West	57,288.60	16-30 Days
391	West	4,193.99	16-30 Days
392	East	94,985.33	16-30 Days
393	East	16,519.18	16-30 Days
394	West	1,49,694.93	16-30 Days
395	West	1,36,906.38	16-30 Days
396	West	8,430.78	16-30 Days
397	West	16,048.45	16-30 Days
398	West	4,236.79	16-30 Days
399	North	5,423.40	16-30 Days
400	North	4,236.80	16-30 Days
401	North	25,342.25	16-30 Days
402	North	31,096.49	16-30 Days
403	North	1,19,446.81	16-30 Days
404	North	57,435.56	16-30 Days
405	North	1,40,215.18	16-30 Days
406	North	58,159.53	16-30 Days
407	North	75,263.61	16-30 Days
408	North	2,96,874.21	16-30 Days
409	North	21,283.77	16-30 Days
410	North	22,082.66	16-30 Days
411	North	13,181.11	16-30 Days
412	North	19,472.11	16-30 Days
413	West	20,707.82	16-30 Days
414	West	2,845.92	16-30 Days
415	North	3,19,834.63	16-30 Days
416	North	2,58,657.98	16-30 Days
417	North	31,840.09	16-30 Days
418	North	2,76,033.08	16-30 Days
419	North	39,800.12	16-30 Days
420	West	11,447.87	16-30 Days
421	West	6,419.38	16-30 Days
422	West	7,189.71	16-30 Days
423	West	19,172.54	16-30 Days
424	West	7,249.60	16-30 Days
425	North	1,23,256.29	16-30 Days
Sheet1

I Dont Want Bucket 16-30 days Column in Pivot.

Overdue Payment_MRL_17.10.2020.xlsb
	A	B	C	D	E	F	G	H
2	Sum of Outstanding Amount	Column Labels
3	Row Labels	>1 Year	121-365 Days	91-120 Days	61-90 Days	31-60 Days	16-30 Days	Grand Total
4	East					2637559.33	1938139.23	4575698.56
5	North	14307.02			287846.84	4355667.59	6642826.35	11300647.8
6	South		6799.43	4276.36	55592.87	14266798.75	1232472.61	15565940.02
7	West	98824.33	4751.19	1988.52		1627224.86	1250065.63	2982854.53
8	Grand Total	113131.35	11550.62	6264.88	343439.71	22887250.53	11063503.82	34425140.91
9
10
11
12
13	Expected Below Output
14
15	Sum of Outstanding Amount	Column Labels
16	Row Labels	>1 Year	121-365 Days	91-120 Days	61-90 Days	31-60 Days	Grand Total
17	East					2637559.33	2637559.33
18	North	14307.02			287846.84	4355667.59	4657821.45
19	South		6799.43	4276.36	55592.87	14266798.75	14333467.41
20	West	98824.33	4751.19	1988.52		1627224.86	1732788.9
21	Grand Total	113131.35	11550.62	6264.88	343439.71	22887250.53	23361637.09
Sheet1

Cell Formulas
Range	Formula
G17:G21	G17	=SUM(B17:F17)

Thanks
mg