thread Re: Can I add a Field to the Custom Report? in Archived Discussions (Read Only)

Can I add a Field to the Custom Report?

jgorman0 — Sat, 26 Feb 2022 17:53:33 GMT

Just started with Square. Would like to create a report that shows sales by Item and the Net Sales. The Item Sales Report does not show Net Sales and the Sales Report does not breakout by Item. I don't see a way to add the Individual items to the Custom Report. Thanks

Re: Can I add a Field to the Custom Report?

ryanwanner — Sat, 26 Feb 2022 20:38:08 GMT

Hello @jgorman0 !

You can add the Net Sales column to the Item Sales report, it's just a little buried.

When you're editing the custom report, add Item Sales to the report. Once that report populates, hover your mouse over the Item Sales title of the report. On the right side, you'll see three options pop up: Filter By, Display By, and Edit Columns.

Click on Edit Columns. On that list is the option to add Net Sales to your report (and remove everything you're not caring about as well).

Hope this helps!

Re: Can I add a Field to the Custom Report?

jgorman0 — Sat, 26 Feb 2022 21:51:31 GMT

Thanks Ryan. Exactly what i was looking for.

Re: Can I add a Field to the Custom Report?

ryanwanner — Sat, 26 Feb 2022 23:03:44 GMT

Glad I could help!