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, b...
  • Shella_A's avatar
    Shella_A
    7 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
2 days 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
    10 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
      7 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

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

        PS yes I know how to do this manually, I was hoping a MYOB report would do it for me!

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.