Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to sum values based on my selections?
I would like to add the month values like if i am selecting month March, then it should add from Jan to Mar. can anyone give me some example?
Assuming that you have Date in your data
Sum({<Date = {">=$(=monthstart(addmonths(max(Date),-2)))<=$(=max(Date))"}>}Amount)
Update: Addmonths
may be like this
Sum({<Date = {">=$(=YearStart(max(Date)))<=$(=max(Date))"}>}Amount)
I further suggest using Date() function to make sure there are no formatting difference
Sum({<Date = {">=$(=Date(YearStart(Max(Date)), 'DateFieldFormatHere'))<=$(=Date(Max(Date), 'DateFieldFormatHere'))"}>} Amount)