quickest way to generate total and % in file?

[SciFiGuy0]

I'm trying to figure out the quickest way to generate totals and % of total in Enterprise Guide.   Is there a way to do it using the Query Builder?

My data looks like this:

Color	Dollar Amount
Red	$2500
Red	$1000
Blue	$125
Blue	$20
Blue	$200

I want to calculate the sum of dollar amount for each color and then the % of the total overall dollar amount for each color.

Thanks

[mohamed_zaki]

Please follow the next steps:

1-Import your data

2-Select Query Builder

3-Drop the Color Column to the Select Data

4.1-Right click on the Dollar Amount column

4.2-Choose Select Summarized Column...

4.3-Choose SUM Distinct in the summary field from the new window opened

4.4-Click NEXT then Finish

5.1-Right click on the Dollar Amount column

5.2-Choose Select Summarized Column...

5.3-Choose MEAN Distinct in the summary field from the new window opened

5.4-Click NEXT then Finish

6-Click RUN

mohamed zaki

[Reeza]

Tasks>Describe>One Way Frequencies

Analysis Variable >Colour

Frequency> Dollar Amount

Optional:

Click Statistics and choose count and percentages only.

Click Results - Create data set with count and percentages.