Former Member

### Possible to automatically group and use sub totals in a measure?

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

10|10000 characters needed characters exceeded