cumulative total for the current month

[Anonymous]

Hi all,

I need to show the current month current year cumulative total.

For example we are in month of may.

So total has to show all the sales till may.

the required output is this:

Month	CY Sales
May	6000

The data can be :

Month    Sales      Year

Jan         1000       2017

Feb         1000       2017

Mar          1000      2017

Apr           1000      2017

May           2000     2017

Apr               100     2016

May              200    2016

any help would be helpful

thanks

Anupama Jagan

[Digvijay_Singh]

Here they are -

Month - Only({<MonthNo={$(=Max({<Year={$(=Max(Year))}>}MonthNo))}>}Month)

Total - Sum(Total {<Year={$(=Max(Year))}>}Sales)

Thanks,