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:

1view.PNG

I change the date formatting:

2changedatedisplayformatting.PNG

Then I create a calculated measure:

/wp-content/uploads/2014/02/3acreate_389038.png

This is the profit ratio:

4profitratio.PNG

Then I create a table to review the profit ratio:

/wp-content/uploads/2014/02/5atable_389044.png

I can switch the “totals” sum for the ratio to average:

6nowavg.PNG

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…

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply