on 02-06-2015 1:35 PM
Hi all
Its my first post here! Hopefully someone can help
I'd like to use subtotals in a measure. What I'm trying to do is calculate ratios. My task is as follows:
I have a similar looking dataset
Rt Product Wt
123 TV 50kg
123 VCR 30kg
123 Laptop 20kg
212 TV 80kg
I'd like to create a 4th a new measure called that works out the ratio of the product weight on the route. If I were doing it in Excel I'd use a sumif function to work out the weight of all products on the route (call this RtWt) and then use this to work out the ratio.
Rt Product Wt RtWt Ratio
123 TV 50kg 100kg 50%
123 VCR 30kg 100kg 30%
123 Laptop 20kg 100kg 20%
212 TV 80kg 80kg 100%
Any idea on how I can solve for the Ratio in Lumira? Please note there are thousands of routes so a manual grouping by Rt would be out of the question, so would using an If statement.
I look forward to hearing from you and hopefully becoming a valued contributor to other discussions as well
Cheers
Ria
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.