Script to create a summary table with filters
Hi allI have a data table with some numerical columns (VAL1, VAL2) and some char columns (CATEG1, CATEG2, CATEG3).I want to write a script to crete a summary table reporting the average value of each numerical value grouped by "CATEG1,23"; this easily done: Data Table( "MyTable" ) <<
Summary(
Group(
:Lot,
:Name( "CATEG1" ),
:Name( "CATEG2" ),
:Name( "CATEG3" ),
),
Mean( :VAL1),
Mean( :VAL2),
Fre
...