2 Replies Latest reply on Nov 24, 2016 8:46 PM by Deborupa Banerjee

Profit/Total Sales for each Category Hi All,

Again I'm posting one question regarding calculations. This time the requirement is easy but I.m not sure why I am not able to achieve this.

Follow the screenshot. Now I want the calculation like the profit of each sub-category should get divided by the total sales of that Category.

Deborupa

• 1. Re: Profit/Total Sales for each Category

HI Deborupa

The problem you've asked is very common and asked many a times but it's not difficult as such. Just extract out the total sales respect to each category first:

{ FIXED [Category]: SUM([Sales])}

Finally, Sum(Profit)/{ FIXED [Category]: SUM([Sales])}

DONE! If values come as 0, means that the denominator is actually too large and you can change the number format to see the actual values, otherwise just reverse the calculation.

Let me know if it helps.

Kajal

1 of 1 people found this helpful
• 2. Re: Profit/Total Sales for each Category

Thanks a lot kajal, This is working as expected.

Deborupa