Forum Discussion

Msampedro's avatar
Msampedro
Helper I
1 year ago
Solved

Order attributes

Hello,   I have the following table "PnL Structure" (not sure if I can consider it as a pure table since doe not appear in the Table view) and I need to give and order to each attribute, in order t...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    DATATABLE returns a table and not a column. You need to modify the table itself and not create a calculated column. Note: The code i gave you was just  a sample which of course didn't include all attribute values.

     

danextian's avatar
danextian
Super User
1 year ago

DATATABLE returns a table and not a column. You need to modify the table itself and not create a calculated column. Note: The code i gave you was just  a sample which of course didn't include all attribute values.

 

  • Msampedro's avatar
    Msampedro
    Helper I
    1 year ago

    Thanks, Finally it was quite easy... just about to edit Datatable formula.... thanks to help me understand the logic.

     

    PnL Structure =
    DATATABLE (
    "Attribute", STRING,
    "Order", INTEGER,
    {
    {"Qty (Liter)", 1},
    {"Qty (KG+EA)", 2},
    {"Net Sales", 3},
    {"ASP, EUR/KG+EA", 4},
    {"ASP, EUR/lt", 5},
    {"Vcogs, EUR/lt", 6},
    {"Variable COGS", 7},
    {"Vcogs, EUR/KG+EA", 8},
    {"Var FPDE", 9},
    {"Var.Contribution", 10},
    {"Fcogs, EUR/KG+EA", 11},
    {"Fcogs, EUR/lt", 12},
    {"F-COGS", 13},
    {"Gross Profit", 14},
    {"GM %", 15},
    {"VM %", 16}
    }
    )