How to sum the Values Month wise

I am having the data like this

But I want to calculate the total sales month wise.

image

I tried the grouping but its not working. Please suggest me the formula regarding the same.

Thanks!

Hi there @Video_by_Pro :blush: !

I made few modifications in your sample :blush: (I hope it’s Ok :blush: )

In the Product Sold Table, I’ve added 2 fields : One to extract the MonthName() from your Date field and one for the Year then I’ve grouped the table by Year and then by Months :blush: .

I also created a table Month Wise in your Month Wise Page, in case the grouping would not be workable for you, after all :blush: .

Hope this helps :blush: !

2 Likes