You need create two more calculations individually for current month and ytd.
sum(if [Current Month] = 'Currrent Month' then [sales] end)
sum(if [Current Month] <> 'others' then [sales] end)
Hope this helps
In the calculation you have used, i guess you have missed giving '<=' for the first row of calculation which will give from starting of the month to till selected month.
Please find the below cal.
if month(order date)<= date then 'YTD'
else-if month(order date) = date then 'current month'
Please mark it as helpful and answered if this solution works for you.
Thanks & Regards,
i think it's not working
Please can you send me workbook
i have to tried that one also but not working
Can you send a sample workbook which reflects your issue as solution may be various depending on what your data looks like?