Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
enclosed is a sample sales chart
i want to add an indicator of customer sales VS total sales
can you help ?
gidon
Hi Gidon,
Change the 'ration' expression to read: Sum(Sales) / Sum (Total Sales)
Hi Gidon,
Change the 'ration' expression to read: Sum(Sales) / Sum (Total Sales)
Hi gidon, ratio expression can be:
=SUM(sales)/SUM(TOTAL sales)
Please refer the attachement . It is now as per your requirement