-
1. Re: Current month and YTD Sales
Zhouyi ZhangJan 3, 2019 6:30 PM (in response to chowdary v)
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
-
2. Re: Current month and YTD Sales
Ravikiran Sarala Jan 3, 2019 11:24 PM (in response to chowdary v)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
-
3. Re: Current month and YTD Sales
chowdary v Jan 4, 2019 1:43 AM (in response to Zhouyi Zhang)i think it's not working
Please can you send me workbook
-
4. Re: Current month and YTD Sales
chowdary v Jan 4, 2019 2:02 AM (in response to Ravikiran Sarala)hi,
i have to tried that one also but not working
-
5. Re: Current month and YTD Sales
Zhouyi ZhangJan 4, 2019 3:48 AM (in response to chowdary v)
Can you send a sample workbook which reflects your issue as solution may be various depending on what your data looks like?
ZZ