Looping through a unique items in a column and then tabulate
Hi all,
My data table consists of 3 columns (Name, Hours, and Money). This is what I wanted to do.
Step 1: Find the unique items in the column "Name". My datatable is dt. Here is what I do.
Summarize(dt, uniqNames = by(:Name));
Show(uniqNames);
This provides me a list
Step 2: For each unique item in the list, I wanted to tabulate the sum of hours and money. For example, for item A, sum of hours...