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

[DataNath · Accepted solution]

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

[jaimearanda]

Thank you so much! I see my mistake was using count distinct rather than count.