Forum Discussion

Kathir's avatar
Kathir
Frequent Visitor
2 years ago
Solved

How to create a aggregated table with additional criteria?

   

 

How to create an aggregated table below based on the table on top? Time is ascending for the top table. Thanks 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Kathir,

    You can use the summarize function to create a new calculated table to aggregate specific field values based on category fields:

    Summaried =
SUMMARIZE (
    Table1,
    Table1[ID],
    Table1[Day],
    Table1[Venue],
    Table1[Zone],
    "Duration(sec)", SUM ( Table1[Duration(sec)] )
)

    Regards,

    Xiaoxin Sheng

4 Replies

  • Kathir's avatar
    Kathir
    Frequent Visitor
    2 years ago

    if you have noticed, refering to the top table, as long as the venue is same row 3 and row 4 (records which are adjacent), i have added 56 + 152 , the result table below shows 208

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Kathir,

    You can use the summarize function to create a new calculated table to aggregate specific field values based on category fields:

    Summaried =
SUMMARIZE (
    Table1,
    Table1[ID],
    Table1[Day],
    Table1[Venue],
    Table1[Zone],
    "Duration(sec)", SUM ( Table1[Duration(sec)] )
)

    Regards,

    Xiaoxin Sheng