How can I show last to last month value in current month in Line chart

[kavita25]

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

[Kushal_Chawda]

Please provide the sample app

[rubenmarin]

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)

[kavita25]

Check the app..

[kavita25]

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

[Kushal_Chawda · Accepted solution]

Please see the attached

[kavita25]

Thank You...It worked