How to get % out of total sales

[#1]

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

[Kushal_Chawda]

try,

sum( total <Item> NetSales)/ sum(total NetSales)

[raajaswin]

Hi Larib,

You can do it by using

sales/sum(Total sales)

[raajaswin]

Check this qvw

[#5]

Hi,

You can refer attach qvw to get desired output.

Hope it will resolve your issue.

Regards

HP Sharma

[Anonymous]

You can try:

=sum(NetSales)/sum(Total NetSales)

[manojkulkarni]

sum(Sales)/ sum(total Sales) or

you can make use of relative option. Expression : Sum(Sales) then check the relative option