Monthly Total

[chris_munns]

Hi All,

Having an issue calculation a monthly total.

I have a table with the number of members by JoinDate. Count of the number of members who joined on that day and a cumulative count;

Next step is to populate the table below;

The table is showing the number of members who joined in the month, regardless of year, of course i can include an expression to provide the current year/month values. This is not what I am after.

The expression for the count of members by month for FY17 is where I would like to start; Jul - 139,295 through to Jan - 144,790 (as per the table above).

So, i am starting with :-

=num( sum( Member_Count) ,'#,###,###')

Grateful for any guidance.

Thanks,

Chris

[sdmech81]

May be use pivote table and there go to calculated dimension and say:

=Month(JoinDate)

Then put your expression >>plss try

[muthukumar77]

Hi,

you can use Month(JoinDate) as Month in script.

then use Month column in pivot table.

[adamdavi3s]

Hi CHris,

I think what you're looking for is something like:

=num( sum( {<year(JoinDate)={"=$(=year(today())"}>}Member_Count) ,'#,###,###')

However I would make life much easier for yourself and create a master calendar for joindate as you can then set some flags etc to pick up the current year