cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

Hi Ria - welcome!

If I understand you correctly, I don't see a way to do this

You could create a running sum of the route weight but then Lumira doesn't allow creation of calculations on running sums/totals.  Perhaps this is a good suggestion for Idea Place?  ideas.sap.com/SAPLumira

Former Member
0 Kudos

Hi Tammy!

Thanks for the quick response and welcome. I'll add this as a suggestion on for the Ideas Place.

Is there perhaps another SAP BI Tool where this would be possible?

Cheers

Ria

TammyPowlas
Active Contributor
0 Kudos

Hi Ria - it depends on your data source; at first look Crystal Reports could likely handle these types of calculations.

Answers (0)