Count and Sum of Group within a Group

jaimearanda

Hi guys, 

I am relatively new to Alteryx and have been struggling with a problem for a while.

I am trying to figure out how to get the count and sum of unique ID's of a group within a group. 

I have attached an image of the input and desired output. I have tried using the Summary tool however, I keep only getting the count/sum of records from the first groupby when I need them counted for the second groupby.

Any help is greatly appreciated.

Best,

Jaime

Capture.PNG

Capture2.PNG

DataNath

Hey @jaimearanda you just need to add a second 'Group By' in your Summarize tool, so your configuration should be:

Card Number > Group By

Store Number > Group By

Subtotal > Count

Subtotal > Sum

Double group by sum and count.yxmd