- redeemeritAsked on February 17, 2016 at 03:40 PM
- JotForm SupportChriistianAnswered on February 17, 2016 at 09:34 PM
If I understand correctly, you want to calculate the total result of selected columns from the Survey Tool - Matrix? If yes, then you can do so by using a form calculation widget. Simply follow this guide on how to set it up for your form: How to perform form calculation in the Matrix field
Once that is set up, the total can then be displayed in the reports created.
Here's a cloned version of your form where I added the form calculation: https://form.jotform.com/60477945980975
You can clone it to your account by following this guide: How to Clone an Existing Form from a URL
Let us know if you need further assistance.
- redeemeritAnswered on February 17, 2016 at 11:46 PMThanks so much for this detailed response.
As I have gotten into this deeper I realized I don't need column totals.
My goal is to rank the 4 topics I listed in the women's retreat form to see
the most requested topic to the least requested.
Is that possible?
- JotForm SupportChriistianAnswered on February 18, 2016 at 01:04 AM
You can use the Visual Report Builder to see the most requested topic. Here is a guide on how to create it: How to Create a Visual Report with your Form Submissions
You can also check out this guide to customize your report even more: How To Use Visual Report Filters
Do let us know if you need further assistance.