Desktop productivity for business analysts and programmers

quickest way to generate total and % in file?

Reply
Occasional Contributor
Posts: 18

quickest way to generate total and % in file?

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:

ColorDollar 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

Super Contributor
Posts: 490

Re: quickest way to generate total and % in file?

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

Grand Advisor
Posts: 17,332

Re: quickest way to generate total and % in file?

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.

Ask a Question
Discussion stats
  • 2 replies
  • 237 views
  • 1 like
  • 3 in conversation