A workaround for this scenario is to use the RATIO_TO_REPORT() OVER () formula in the Formula column, and then select one of the Round functions from the Function drop down menu. The steps below show how to create a Transaction Saved Search to show the total sales per customer and the percentage related to the total sales of the company. The search results include… Continue reading RATIO_TO_REPORT() OVER () —- % of Total Function alternative