Hello, I need help to create a formula to give the % for each lead source.
I have attached an example of what the chart in the report looks like. I know I need to dive the subtotals by the total but can't seem to find a way to do it. Any help is greatly appreciated.
3 Antworten
@Bella Cotrone For this you need use the PARENTGROUPVAL function when constructing the summary level formula. Then, make sure in the "Display" tab of the formula editor, you group by the Lead Source row group.
1. In the report editor, click on the arrow next to "Columns"
2. Make sure the "Formula Output Type" is "Percent"
3. Set the Lead Source row group
4. Paste the following formula and save
RowCount / PARENTGROUPVAL(RowCount, GRAND_SUMMARY)
