3 Replies Latest reply on Jan 7, 2019 3:39 PM by Deepak Rai

How To Total Specific Groups?

Howdy all!

Attached is a worksheet in 2018.3

I have a situation where I need to show % totals across the board, but I also need 3 columns. 1 column for raw totals and then 2 more columns for specific group totals.

Sounds confusing in writing but hopefully an image helps. I want to add 2 columns to the following image, one for each of the highlighted customers:

If I try something like the following code it adds so many extra rows to the table. In this scenario can it be calculated so you see the total quantity is 7, Anne's is 2, and Mike's is 5 without all the excess?

Total Anne Mcfarland

IF [Customer Name] = 'Anne Mcfarland'

THEN { FIXED [State], [Customer Name], [Product Name]:

SUM([Quantity])}

END

Thanks for any assistance with this!

• 1. Re: How To Total Specific Groups?

{ FIXED [State], [Customer Name], [Product Name]:

SUM(IF [Customer Name] = 'Anne Mcfarland' THEN [Quantity] END)}