Group Date to get each Sum

[KamenRider]

Hi guys,

I would like to seek for your ideas on how I can group the dates that updates daily and then get the sum of each group date. See sample below. I have tried the tile tool but it is creating duplicate values when I added the summarize tool. Aside from that I need to specify the date in order to get the grouping. I hope you could provide me solution without allowing me to enter or specify the date manually.

 

I have also attached the excel file.

Thanks,

Kamen

[binu_acs]

@KamenRider what is the expected output, is that some like below?

[KamenRider]

Hi @binu_acs 

Thanks for the response. I believe that is not the results. You may base the results on the excel I have provided, the "group amount". What I did is that I added all of the amount for certain did like for the sample below. This is same for the other dates.

 

Please let me know if you have any questions.

Kamen

[binu_acs · Accepted solution]

@KamenRider 

[KamenRider]

Thanks @binu_acs 

I think you got the grouping. Case solved.

Kamen