Forum Discussion

GabrieleFarina's avatar
GabrieleFarina
Qrew Member
4 years ago

Use total group from summary report as a field in the same table

Hi, I'm creating a summary report to calculate how many record has an answer A,B or C. The report works great and it gives me at the bottom a TOTAL, which is the right number. Now what I want do ...
Formulas and functions
reports and charts
GabrieleFarina's avatar
GabrieleFarina
Qrew Member
4 years ago
I want to do that just in this report.

------------------------------
Gabriele Farina
------------------------------
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
4 years ago
If you're wanting to do that just in the report and don't need to use that number anywhere else, you can add a 2nd instance of the field you want to show the % of (Amount, for example) in the 'Summarize Data' section. Then, for the 'Display As' selection, select 'Percent of Column Total'

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------