sum for group wise

[Anonymous]

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

[Jihwan_Kim]

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.

[Pragati11 · Accepted solution]

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