Forum Discussion

activemobility's avatar
activemobility
Trusted Cover User
2 days ago
Solved

Product Category % Sales

Hi

We group products under Categories.

 

eg  Bedroom, Toilet, Seating

 

We would like to know how to run a report to show what is the total % of sales for that category.

 

I have had a look, but cant seem to do what I want. 

eg Sales Analyse - Additional Filter - select Category - only shows Total $ Sales not % 

 

 Is this doable?

 

 

  • Shella_A's avatar
    Shella_A
    4 hours ago

     Hi activemobility,

     

    To find the percentage of Product Category sales ($35,000) out of the total sales ($1,000,000), you can use the following formula:

     

    (Product Category Sales / Total Sales) * 100

    So, in this case:

    ($35,000 / $1,000,000) * 100 = 3.5%

     

    Therefore, the $35,000 in Product Category sales represents 3.5% of the total sales. For further assistance on this matter kindly reach out to our support team directly. You can use Live Chat via our virtual assistant, MOCA, or by submitting a support case via MyAccount.

     

     

    Regards,

    Shella

  • Shella_A's avatar
    Shella_A
    MYOB Moderator
    24 hours ago

    Hi activemobility,

     

    To run a report showing the total percentage of sales for each product category in MYOB, you can use the % Margin feature. You can add the % Margin to the report by using the insert/modify option before running the report. This will give you a percentage that reflects the margin for each category. If you need more specific customization, you can create a custom report tailored to your needs. This can help you automate the calculation and presentation of sales percentages by category. See this link for more information.

     

     

    Regards,

    Shella

    • activemobility's avatar
      activemobility
      Trusted Cover User
      7 hours ago

      Hi Shella_A 

       

      Yes I had already looked at that, but how I read it, the %Margin shows the margin %. 

       

      If the Product Category sales are say $35000, and total sales are $1000000, what percentage is the $35000

      • Shella_A's avatar
        Shella_A
        MYOB Moderator
        4 hours ago

         Hi activemobility,

         

        To find the percentage of Product Category sales ($35,000) out of the total sales ($1,000,000), you can use the following formula:

         

        (Product Category Sales / Total Sales) * 100

        So, in this case:

        ($35,000 / $1,000,000) * 100 = 3.5%

         

        Therefore, the $35,000 in Product Category sales represents 3.5% of the total sales. For further assistance on this matter kindly reach out to our support team directly. You can use Live Chat via our virtual assistant, MOCA, or by submitting a support case via MyAccount.

         

         

        Regards,

        Shella

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.