Very hard to slove

[smartguy]

Hello All,

Good day !!!!

I have excel in the below format.

Excel Workbook
	A	B	C	D
1	Name	Desc	Status	Spend
2	ravi	Good boy	1	10
3	kumar	Ave	3	10
4	ravi	Good boy	1	20
5	ravi	Good boy	2	30
6	kumar	AVE	1	40
7	suresh	MED	1	50
8	sub	MED	3	60
9	ravi	Good boy	2	70
10	ravi	Good boy	3	80
11	ravi	Good boy	1	20
Sheet1

I need sum of value based on name and status.


And also i need Descrption also.



It is possible in VBA.

Excel Workbook
	F	G	H	I	J
1	Name	DESC	Status 1	Status 2	Status 3
2	ravi	Good boy	50	100	80
3	kumar	AVE	40		10
4	sub	MED			60
5	suresh	MED	50
Sheet1

Please help on that...

 

[smartguy]

Hi MR. Peter_SSs How can i get desc in Pivot?

 

[Sandeep Warrier]

Hi MR. Peter_SSs How can i get desc in Pivot?

Name & Desc in the "Row" part of the pivot table layout. Status in the Column part and Spend in the data part (choose Sum of spend).
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[smartguy]

But i get this format only..

Excel Workbook
	A	B	C	D	E
3	Sum of Spend	Column Labels
4	Row Labels	1	2	3	Grand Total
5	kumar	40		10	50
6	Ave	40		10	50
7	ravi	50	100	80	230
8	Good boy	50	100	80	230
9	sub			60	60
10	MED			60	60
11	suresh	50			50
12	MED	50			50
13	Grand Total	140	100	150	390
Sheet6

 

[Sandeep Warrier]

I dunno why you get incorrect results...

Excel Workbook
	A	B	C	D	E	F	G
2
3	Sum of Spend		Status
4	Name	Desc	1	2	3	Grand Total
5	kumar	Ave	40		10	50
6	ravi	Good boy	50	100	80	230
7	sub	MED			60	60
8	suresh	MED	50			50
9	Grand Total		140	100	150	390
10
Sheet4

Excel 2003<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[Peter_SSs]

As stated by Sandeep, you have to drag/drop both 'Name' and 'Desc' from the Pivot Table Field List to the Row Fields area of the Pivot Table.

Do you have headings in each column of your data?

 

[smartguy]

I Got it ...

Thanks all

Special thanks to

1.sandeep.warrier

2.Peter_SSs

Thanks once again...