DB2 graphic QMF Version 8

Cumulative percentage of total

Select a column, then select Results--> Grouping and Aggregation--> Cumulative Percentage of Total to display the values in the column as a percentage value of the group total and a percentage value of the column total. A summary row at the bottom of the query results shows the sum of the percentages.

For example, within DEPT 42, Wheeler earns 44.60% of the commissions, while Williams earns 55.40%, and Fraye earns no commission. Overall, this DEPT 42 earns 5.75% in commissions for the company.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004