nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Product Category % Sales

activemobility

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?

Find more posts tagged with

Accepted answers

Shella_A

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

All comments

activemobility

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

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