Hi, Chowdary

You need create two more calculations individually for current month and ytd.

[curr_Month_sales]:

sum(if [Current Month] = 'Currrent Month' then [sales] end)

[YTD]:

sum(if [Current Month] <> 'others' then [sales] end)

Hope this helps

ZZ

Hi Chowdary,

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'

else 'others'

end.

Please mark it as helpful and answered if this solution works for you.

Thanks & Regards,

Ravikiran S

Can you send a sample workbook which reflects your issue as solution may be various depending on what your data looks like?

ZZ