09-16-2014 05:09 PM
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:
I want to calculate the sum of dollar amount for each color and then the % of the total overall dollar amount for each color.
09-16-2014 05:58 PM
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
09-16-2014 06:31 PM
Tasks>Describe>One Way Frequencies
Analysis Variable >Colour
Frequency> Dollar Amount
Click Statistics and choose count and percentages only.
Click Results - Create data set with count and percentages.