Count of variables in multigrouping

Hi everyone,

I haven`t been able to solve this problem for a few days now. I have a data set that needs to be grouped and have the count of how many times this variable appeared in this group as shown bellow. However, everytime I try to group these variables and when I try to find the count of these variable I can only find a right count for Var1.

Sample input data set:

Required result:

Sample Result.jpg

Thank you.

Common Use Cases

Best Practices

Preparation

Accepted answers

You can make the duplicates NULL but there isn't a way to merge cells like you've visualized. That would be applying a hierarchy to the data.

GroupCounts2.yxmd

All comments

I believe what you want to do is a series of summaries and subsequent joins. Is this what you were looking for?

GroupCounts.yxmd

Thank you. It`s more than I had.

But it would still be very nice to have Var1 mentioned only once, like we can have in pivot tables. Is that even possible?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703