Month Count

[Anonymous]

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!!

[vishsaggi]

Can you share a sample to look into and work on?

[devarasu07]

Try like this,

SUM({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} SoldQty)

[devarasu07 · Accepted solution]

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)

[Anonymous]

Thanks Devarasu. This is what i was looking for.