Lumira: Practice Custom Calculation – Aggregation Options

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…