1 of 1 people found this helpful
You do not need a LOD.
Can just do sum([Revenue])/sum([Number Of Customers])
If you have a customer Name/ID in the data, then you may need a LOD to get revenue for each customer.
From you data set,
or even this works.
If you are not disclosing whole the data info, please show us everything to get absolute help..
Revenue_SM_10.4.twbx 26.9 KB
Thanks guys. i was looking for LOD function for this case but doing sum (revenue)/sum (number of customers) is another option