Pivot Table Sub Total

[kumara_faith]

Hi,

I have my data table as follows:

Excel Workbook
	B	C	D	E	F	G
3	Branch	Voucher No	Voucher Date	Stamping Amount	Loan Amount	Policy No
4	Texas	1125487258	1/5/2015	50	100	HG1455879255
5	Houston	1125487259	1/6/2015	100	200	HG1455879256
6	New York	1125487260	1/7/2015	20	500	HG1455879257
7	Chicago	1125487261	1/8/2015	45	200	HG1455879258
8	Texas	1125487262	1/9/2015	600	100	HG1455879259
9	Houston	1125487263	1/10/2015	80	200	HG1455879260
10	New York	1125487264	1/11/2015	74	100	HG1455879261
11	Chicago	1125487265	1/12/2015	52	200	HG1455879262
12	New York	1125487266	1/13/2015	5	200	HG1455879263
13	Chicago	1125487267	1/14/2015	25	300	HG1455879264
Sheet1

I have done a pivot table but when I try to get the subtotals for each branch, it becomes like this:

Excel Workbook
	A	B	C	D	E	F
4	Branch	Voucher Date	Voucher No	Policy No	Sum of Stamping Amount	Sum of Loan Amount
5	Texas	1/5/2015	1125487258	HG1455879255	50	100
6	*	*	1125487258 Total	*	50	100
7	*	1/5/2015 Total	*	*	50	100
8	*	1/9/2015	1125487262	HG1455879259	600	100
9	*	*	1125487262 Total	*	600	100
10	*	1/9/2015 Total	*	*	600	100
11	Texas Total	*	*	*	650	200
12	Houston	1/6/2015	1125487259	HG1455879256	100	200
13	*	*	1125487259 Total	*	100	200
14	*	1/6/2015 Total	*	*	100	200
15	*	1/10/2015	1125487263	HG1455879260	80	200
16	*	*	1125487263 Total	*	80	200
17	*	1/10/2015 Total	*	*	80	200
18	Houston Total	*	*	*	180	400
19	New York	1/7/2015	1125487260	HG1455879257	20	500
20	*	*	1125487260 Total	*	20	500
21	*	1/7/2015 Total	*	*	20	500
22	*	1/11/2015	1125487264	HG1455879261	74	100
23	*	*	1125487264 Total	*	74	100
24	*	1/11/2015 Total	*	*	74	100
25	*	1/13/2015	1125487266	HG1455879263	5	200
26	*	*	1125487266 Total	*	5	200
27	*	1/13/2015 Total	*	*	5	200
28	New York Total	*	*	*	99	800
29	Chicago	1/8/2015	1125487261	HG1455879258	45	200
30	*	*	1125487261 Total	*	45	200
31	*	1/8/2015 Total	*	*	45	200
32	*	1/12/2015	1125487265	HG1455879262	52	200
33	*	*	1125487265 Total	*	52	200
34	*	1/12/2015 Total	*	*	52	200
35	*	1/14/2015	1125487267	HG1455879264	25	300
36	*	*	1125487267 Total	*	25	300
37	*	1/14/2015 Total	*	*	25	300
38	Chicago Total	*	*	*	122	700
39	Grand Total	*	*	*	1051	2100
Sheet2

How do get the pivot table to show the subtotal only for each branch and not for every line ?

Appreciate all the help.

 

[Latha]

Is this how you wanted the pivot table to be shown ?

Row Labels Sum of Stamping Amount Sum of Loan Amount
Chicago 122 700
Houston 180 400
New York 99 800
Texas 650 200
Grand Total 1051 2100

If yes : pick and drop "Branch" Under "Row Lables", then "stamping amount" and "Loan Amount" Under "Values" in the Pivot table field list.

 

[SpillerBD]

Right Click on the items you don't want subtotaled and un-check the subtotal.
Conversely, turn off subtotals, then right click a State value and select subtotal...