on 2022 Sep 26 9:24 PM
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
Request clarification before answering.
This should do a job:
=Sum([Quantity]) In ([Group Description])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Kristina, that did it!
User | Count |
---|---|
75 | |
30 | |
9 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.