How to separate products and prices in separate cells in the reports?

  • Profile Image
    Asked on April 23, 2019 at 08:40 PM

    I want to be able to generate reports based on items purchased through jot form. People have bought books, t-shirts, tickets and more but when I want to get totals for a specific item, I can't. The self generated spreadsheet lumps all of the purchased items in one column, which defeats the purpose of this spreadsheet.

    This is a re-post of a comment on How to Use Visual Report Filters?

  • Profile Image
    Answered on April 23, 2019 at 10:39 PM

    You may check the Grid report:

    To see the total of each product separately, you can configure the products outside of the payment field using the traditional elements like dropdown for quantity, Image element if you want to show the picture of the product, text box, multiple choice to select the sub-products. Then pass the total amount to the payment field.

    Please check this guide:

    Let us know if you have further questions.