Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Contributor

Using the profit ratio (profit divided by sales) you have to pay attention to the total lines.

First I select order ID, order date, sales and profit from my data set:

I change the date formatting:

Then I create a calculated measure:

This is the profit ratio:

Then I create a table to review the profit ratio:

I can switch the "totals" sum for the ratio to average:

So the -.25 is the "average" of the profit ratios.  I'd like it to be the sum of the profit divided by the sum of the total sales which would be a .19 ratio but I am not sure how to get there.  To be continued...

1 Comment
Labels in this area