cancel
Showing results for 
Search instead for 
Did you mean: 

Create Variable to sum measure for dimension with matching values

707

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

View Entire Topic
krisa24
Participant
0 Kudos

This should do a job:

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

Thanks Kristina, that did it!