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…
thank you for sharing the knowledge, how can i do a count on order no.