summarizing column value

[harshoyal67]

i want to summazige my coloum value and summarize it in to one value set, so as to get one spent and click value for one advertisement.

example

       Advertisement           datetime                          hourly_spent

1    fb-2342234-111       6/12/2017 10:2:42 pm     250

2    fb-2342234-111       6/12/2017 11:2:42 pm     420

3    fb-2344334-211       6/12/2017 10:2:42 pm     784

4    fb-2347556-311       6/12/2017 10:2:42 pm     985

so i want to get one cumulative value for 1 and 2 data set. that is

       Advertisement           datetime                          hourly_spent

      fb-2342234-111                                                     670

help me with this solution

[Anonymous · Accepted solution]

HI @harshoyal67,

You can simply use 'summarize' function to achieve your requirement, below is the sample formula.

Create a new table to store the summary result:

Summary table=SUMMARIZE(Table,[Advertisement],"hourly_spent",SUM(Table[hourly_spent]))

Regards,

Xiaoxin Sheng