Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I want to find the percentage of sales of particular item out of net sales. My data is lyk-
Item Net Sales % sales of item
600
A 100 how to calculate dis field
B 200
C 300
Regards
Ali
try,
sum( total <Item> NetSales)/ sum(total NetSales)
Hi Larib,
You can do it by using
sales/sum(Total sales)
Check this qvw
Hi,
You can refer attach qvw to get desired output.
Hope it will resolve your issue.
Regards
HP Sharma
You can try:
=sum(NetSales)/sum(Total NetSales)
sum(Sales)/ sum(total Sales) or
you can make use of relative option. Expression : Sum(Sales) then check the relative option