Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to show trend Month wise, but my logic is to show Last to last month value in current value if the day is less than 7.
I am able to do it in text box but not in Line Chart
For e.g
sum Sales for Jun is 200
and Current Month is August date 07/08/2015
so the sum of sales for Aug month should be 200
Hope you understand and provide me with great solution.
Regards,
Kavita
Please see the attached
Please provide the sample app
Hi Kavita, hope this expression helps you:
If(Day(Max(Date))>=7, Sum(Sales),
Above(Sum(Sales))) // This gets your previous loaded month (for 07/08 will get Jul)
Check the app..
Above( sum(Sales),2) gave me the values for June This is for below 7.
Also I want for Above 7 or equal to 7 it should give me the values for Jun
Please see the attached
Thank You...It worked