Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please if any one can help me on the solution.
I need to get the data for the previous months. For Eg:- If year is 2017 and Month selected is April then i should get the count records of (Jan+Feb+March+April). If i click March then it should get the count records of (Jan+Feb+March)
its bit urgent.
Thanks in Advance!!
Hi,
Refer to the attached sample, just use below kind of expression (productid changed to your field)
for the count,
Count({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} ProductId)
Can you share a sample to look into and work on?
Try like this,
SUM({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} SoldQty)
Hi,
Refer to the attached sample, just use below kind of expression (productid changed to your field)
for the count,
Count({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} ProductId)
Thanks Devarasu. This is what i was looking for.