Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

sum for group wise

Hi Team,

 

I have below table1 and i need result table2, kindly help me.

 

I need sum of Material.

 

Table 1

 

 

 

Table 2:

Thanks,

KV's

Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    HI Anonymous ,

     

    If you want this on a table visual, then follow the steps:

    1. Create a table visual
    2. Move MATERIAL column to it.
    3. Move SUM(VALUE) column to it. 

    Something like this with the data at my end:

     

    Thanks,

    Pragati

     

2 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    5 years ago

    HI Anonymous ,

     

    If you want this on a table visual, then follow the steps:

    1. Create a table visual
    2. Move MATERIAL column to it.
    3. Move SUM(VALUE) column to it. 

    Something like this with the data at my end:

     

    Thanks,

    Pragati

     

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, Anonymous 

    You can simply create a table visualization and drag your fields into it, like below picture.

    It will automatically sum, or you can choose the function like count, min, max, etc..

     

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.