New table of Column Names and Column Totals

hacketkm

I have a data table that looks like the one below.

Date	ItemA	ItemB	ItemC
1/1/2005	2	10	112
1/2/2005	2	10	112
1/3/2005	3	10	112
1/4/2005	3	10	112
1/5/2005	3	10	112

I want to make a new data table with two columns:

Item	Total
ItemA	13
ItemB	50
ItemC	560

I have tried using Tabulate() and Transpose() and Summary() and cannot find the best way to do this. Can anyone help me out?

pmroz

Slightly improved script.  Replace My Table with the name of your original data table.  The tabulate command below will sum up the data column, split out by the Label (ItemA, ItemB, ItemC).

dt = data table("My Table");

stack_dt = dt << Stack(

    columns( :ItemA, :ItemB, :ItemC ),

    Source Label Column( "Label" ),

    Stacked Data Column( "Data" )

);

stack_dt << Tabulate(

    Show Control Panel( 0 ),

    Add Table(

        Column Table( Analysis Columns( :Data ) ),

        Row Table( Grouping Columns( :Label ) )

    )

);