Dear Team,
I stuck a issue. My Requirement is
Suppose we have a Sale Data from Apr to Jul
And I want to Result
When a person select May's any date then Sale would be Sum of From (01/04/2016 to 30/04/2016) Sale Showed in Report.
But When i select Apr's Month Any Date then it Showing All Sale.
But it should be sum of (01/04/2016 to 31/03/2016) Sale Zero.
but it is showing All Sale Value. Kindly Help me only for Solevingthis Requirement.
For this i have make two Variable
1. V_End_Month= Date(MonthStart(RangeMin(Date(Floor(Max(Link_Date)),'DD/MM/YYYY'),Date(Today()-1,'DD/MM/YYYY')),0)-1,'DD/MM/YYYY')
2.v_YearStart= DATE(MonthStart(YEARSTART(vCurrentDate,0,4)),'DD/MM/YYYY')
For Making vCurrent Date I use this Formula
vCurrentDate=DATE(RANGEMIN(DATE(FLOOR(MAX(Link_Date)),'DD/MM/YYYY'),DATE(TODAY()-1,'DD/MM/YYYY')),'DD/MM/YYYY')
And I am using Expression in frontend
=Sum({$<Link_Date={"<=$(V_End_Month)>=$(vYearStart)"},[Fiscal Year],[FY Year Name],[Fiscal Quarter],[Fiscal Month]>} Net_Value)
For this i am sharing excel.And Qvw Maker
