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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
36 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |