Summing up data based on several categories

[RNSEG]

I have a set of data that consists of 6 columns (Fund Name, Class Name, Investor ID, Investor Name, Activity Name, and Values) 

I want to sum the Values based on the Investor name, Class Name, Fund Name and Activity Name. How would i go on about this using the summarize tool or is there another tool that can have this done? 

See below simplified dataset and desired outcome. 

Fund Name	Class Name	Investor ID	Legal name	Activity Name	Values
ABC Fund	Class A	101	John Smith	Beginning Value	1,000
ABC Fund	Class A	101	John Smith	Subscription	500
ABC Fund	Class A	101	John Smith	Gain/(Loss)	100
ABC Fund	Class A	101	John Smith	Ending Value	1,600
ABC Fund	Class A	101	John Smith	Beginning Value	500
ABC Fund	Class A	101	John Smith	Subscription	0
ABC Fund	Class A	101	John Smith	Gain/(Loss)	50
ABC Fund	Class A	101	John Smith	Ending Value	550
CDE Fund	Class B	102	James Bond	Beginning Value	1000
CDE Fund	Class B	102	James Bond	Subscription	0
CDE Fund	Class B	102	James Bond	Gain/(Loss)	500
CDE Fund	Class B	102	James Bond	Ending Value	1,500
CDE Fund	Class B	101	John Smith	Beginning Value	600
CDE Fund	Class A	101	John Smith	Subscription	0
CDE Fund	Class A	101	John Smith	Gain/(Loss)	60
CDE Fund	Class A	101	John Smith	Ending Value660	660

And the desired outcome would look like this where John Smith in ABC fund was summed together based on the fund name, Class name, and legal Name: 

Fund Name	Class Name	Investor ID	Legal name	Activity Name	Values
ABC Fund	Class A	101	John Smith	Beginning Value	1,500
ABC Fund	Class A	101	John Smith	Subscription	500
ABC Fund	Class A	101	John Smith	Gain/(Loss)	150
ABC Fund	Class A	101	John Smith	Ending Value	2,150
CDE Fund	Class B	102	James Bond	Beginning Value	1000
CDE Fund	Class B	102	James Bond	Subscription	0
CDE Fund	Class B	102	James Bond	Gain/(Loss)	500
CDE Fund	Class B	102	James Bond	Ending Value	1,500
CDE Fund	Class A	101	John Smith	Beginning Value	600
CDE Fund	Class A	101	John Smith	Subscription	0
CDE Fund	Class A	101	John Smith	Gain/(Loss)	60
CDE Fund	Class A	101	John Smith	Ending Value660	660

[ShankerV]

Hi @RNSEG 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @RNSEG 

Step 1: Input

Step 2: 

ReplaceChar([Values], ",", "")

Step 3: 

Step 4: 

Many thanks

Shanker V

[RNSEG]

Hi Shanker, 

Thanks this worked well. I am just realizing within the datasets, there are values that shouldn't be summed up which is a percent return (displayed as 0.50 which is 50% return). How would I go on about not having this specific row not summed up in the summarize tool? 

Fund Name	Class Name	Investor ID	Legal name	Activity Name	Values
ABC Fund	Class A	101	John Smith	Beginning Value	1,000
ABC Fund	Class A	101	John Smith	Subscription	500
ABC Fund	Class A	101	John Smith	Gain/(Loss)	100
ABC Fund	Class A	101	John Smith	Ending Value	1,600
ABC Fund	Class A	101	John Smith	Net Return	0.50
ABC Fund	Class A	101	John Smith	Beginning Value	500
ABC Fund	Class A	101	John Smith	Subscription	0
ABC Fund	Class A	101	John Smith	Gain/(Loss)	50
ABC Fund	Class A	101	John Smith	Ending Value	550
ABC Fund	Class A	101	John Smith	Net Return	0.50

And the desired outcome would look like this where John Smith in ABC fund was summed together based on the fund name, Class name, and legal Name: 

Fund Name	Class Name	Investor ID	Legal name	Activity Name	Values
ABC Fund	Class A	101	John Smith	Beginning Value	1,500
ABC Fund	Class A	101	John Smith	Subscription	500
ABC Fund	Class A	101	John Smith	Gain/(Loss)	150
ABC Fund	Class A	101	John Smith	Ending Value	2,150
ABC Fund	Class A	101	John Smith	Net Return	0.50

[MilindG]

@RNSEG 

[RNSEG]

Thanks MilindG. This is helpful