Hi,

 I have a dataset with many columns. I wanted to display the result set of groupby of one columns in one cell and total of the same rows in

 adjacent cells. Also when the user expands the result set he should be able to view the result set .

 Please let me know how to do this. The samples are as below.

 Existing one:- 

 

Custodian	Account	Advisor	Ben Owner	Product	Date1 Quan tity	Date2 Quan tity	Variance 1	Latest Fili ng Date	Latest Fil ing Positi on
Northern Trust	*501 C3 JENNISON *	Jennison Associates LLC	*501 C3		37600	38700	-1100	#############	21940515
Northern Trust	*HSBC N.A. HLDG. - SOUTHEASTERN ASSET-SL*	Southeastern Asset Management, Inc.	*HSBC N.A. HLDG.		188000	188000	0	#############	46763734
Northern Trust	*ILLINOIS MUTUAL LIFE INSURANCE COMPANY*	Corresponding Bank (US)	*ILLINOIS MUTUAL LIFE INSURANCE COMPANY*		35000	35000	0
Northern Trust	*POLICE RETIREMENT SYSTEM OF ST. LOUIS MFS INSTITUTIONAL ADVISORS	MFS Investment Management	*POLICE RETIREMENT SYSTEM OF ST. LOUIS		35060	30360	4700	#############	23519297

 

Required one:- 

              Advisor                                                              D1 Quantity   D2 Quantity      Variance     
     +    AXA Rosenberg Investment Mgmt LLc (3 items)             400              400                  0              
     +    Blue Chip  Mgmt LLc (3 items)                                     250               600                  2                  

v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

 

Here in the Required section you see the Advisor column is grouped and the result set is present in first column.Similarly the total of other  columns of the same rows grouped based on advisor is present under adjacent columns.

Please let me know can this be done.

 

Thanks,

Shashi 

  v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}