Navigate to Reports>Saved Searches>All Saved Searches>New
Select Search Type = Transaction
Navigate to Criteria tab>Standard subtab>Filter column: make sure that you set a filter for Posting = is true.
To calculate for the Gross Profit percentage based by item here are the following settings that you need to have under Results tab>Columns subtab>Field column:
a. Item | Summary Type: Group
b. Formula (Percent) | Summary Type: Average | Formula: round(sum(case when {accounttype} in (‘Income’,’Cost of Goods Sold’) then nvl({grossamount},0) else 0 end)/nullif(sum(case when {accounttype} = ‘Income’ then nvl({grossamount},0) else 0 end),0),4)
-Hit Save & Run button