Compute Totals and Percentages

(Keshav Chennakeshav) Here is a tip to compute totals and percentages using the GROUPING and ROLLUP functions in summary queries. To get the correct percentage, the WHERE clause in the runtime table (designated with the alias “ts” below) should match the WHERE clause of the query. The output can be

Read More - Register for Free Membership