Add Counter for Unique Cases in Groups
Hi all,
How can I write an integer value counter to increment unique values in column B within group A, to do this?
Here is what I have tried so far:
dt_Table1 = Data Table("Table1");
dt_Table1 << New Column("Dataset", Numeric, "Nominal", Set Selected);
Sum1 = dt_Table1 << Summary(Group(:Group, :Date));
Sum2 = Sum1 << Summary(Group(:Group));
:N Rows << Set Name("N Datasets in Group");
dt_Tab
...