Group Data Table by Columns


Im learning Ui Path and experiencing challenges to group data by Expense amounts within a Data Table.

I would like to group the data based on the columns “HR cost center”, “Project”, “Expense Type”, GPID descending ordered by “HR cost centers”

Below my source data table (only yellow highlighted columns used for output)

Below my target data table after grouping (Output)

I try to use the defaultview function but didnt work out. I definitely need to cast the expense amount column to a numeric data type before the grouping happens.

Any help would be much appreciated.

Thank you

Test.xlsx (14.6 KB)