Skip to Content
Author's profile photo Tammy Powlas

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…

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Muhammad Ali Toor
      Muhammad Ali Toor

      thank you for sharing the knowledge, how can i do a count on order no.