Create Variable to sum measure for dimension with matching values

[former_member1335452]

I have a report that pulls the Item Description, Quantities and Group Description:

Item Description Quantity Group Description

Blue Sweater Small 500 Blue Sweater

Blue Sweater Medium 750 Blue Sweater

Red Sweater Large 900 Red Sweater

Red Sweater X-Large 500 Red Sweater

I'm looking to add a fourth column that calculates the total quantity of each Group Description (see example below). I'm able to do this using SUMIFS after downloading the report to a spreadsheet but I need the calculation to happen in the report. I've been trying to create a Variable that calculate the Group Quantity but so far I haven't been able to find works. Does anybody have an idea how to get this done? Thanks in advance.

Item Description Quantity Group Description Group Quantity

Blue Sweater Small 500 Blue Sweater 1250

Blue Sweater Medium 750 Blue Sweater 1250

Red Sweater Large 900 Red Sweater 1400

Red Sweater X-Large 500 Red Sweater 1400

[jerryjanda]

Hi, thenides:

Welcome to the SAP Community! We're glad you've come here to get answers to your questions. If you're also interested in connecting with community members, please pay a visit to our Welcome Corner. You'll need to sign up, but it's a great way to interact with peers and connect with other experts!

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

You should also make sure your e-mail notifications are turned on for "Comments and answers to my questions and questions I follow" at #communications -- so you won't miss any replies to your question.

In addition, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

* Make sure you've applied the appropriate tags -- because if you don't apply the correct tags, the right experts won't see your question to answer it.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond. As it stands, I don't know if there is enough information here for members to understand your issue. So please consider revising your question because I'd really like to see you get a solution to your problem!

Please let me know if you require any additional guidance!

All the best,

--Jerry

[jerryjanda]

Hello again, thenides:

I'm glad to see you've gotten answers to your question! If it helps you, please make sure to accept (you'll see the "accept" option beneath the question) -- so members with similar issues will be able to find a solution to their problems too.

If it doesn't help, you can always leave a comment providing more details that can guide members who wish to assist you.

I hope that this guidance is useful -- and we look forward to your next question for the community!

All the best,

--Jerry

[krisa24 · Accepted solution]

This should do a job:

=Sum([Quantity]) In ([Group Description])

[former_member1335452 · Accepted solution]

Thanks Kristina, that did it!

[zeshanshafqat79]

Hello Nicolas,

Create a 2 variable name ABC and GHJ their type measure in webi.

use variable ABC formula 1 =sum(Quantities) where (XYZ ="Blue Sweater")

use variable GHJ formula 2 = sum(Quantities) where (XYZ ="Red Sweater")

after the formula is created then insert a new column on the right side then create a formula

=if(XYZ ="Blue Sweater") then (ABC) Else (GHJ)

[former_member1335452]

Hi Zeshan,

I was so focussed on simplifying my example that I forgot to mentions that the query generates thousands of Item Descriptions within hundreds of Group Descriptions which are continuously changing. This makes it impossible to create a variable for each Group Description as suggested. This is where I'm stumbling.

[Privete_member__946359]

it is possible to make backed edition by making demension to measure