+ Start a Discussion
kevinedelmannkevinedelmann 

Grouping and Summing Related List items

Ihave a need to group and sum a custom object related list and show it in a standard page layout on the account page.

 

Related list items are as follows:

 

Order Widget Name  Qty

1        ABX                 5

2        ABX                 2

3        WWW              3

5        WWW              3

9        ABC                 3

 

Need it to show on the account page as follows:

 

Widget Name          Sum Qty

ABX                              10

WWW                             6

 

I am by no means a programmer but dabble in Apex/Visualforce.

 

Thanks for any help.


Kevin

GoodGrooveGoodGroove

You have to create an embedded vf page with an controller extension, to make this work. Check out Andrews Article "Group, Sum and Order data in Apex" this may help.

 

HarmpieHarmpie

If the Widget Names are coming from a restricted domain of values, you could use a roll-up-summary field on Account to count the values per Widget (1 roll-up field per Widget type).... ofcourse if the number of widget types is not exceeding the number of allowed roll-up-fields

 

If the Widget can contain anything and is not restricted OR there's too many Widget types to fit in the max. number of roll-up-fields, then I agree with GoodGroove.