Sales of previous months

[Anonymous]

Hello,

i have data since Jan15 until today and i need to get in each month the sales of the previous months,

so for example for august 16, i need to get the data from jan 15 to july16.

thank you

[sunny_talwar]

May be try this:

Above(sum({<Year_Month>}sales)) * Avg(1)

[Anonymous]

Hello,

For march 15 it should get the data of jan 15 and feb 15

[sunny_talwar]

This:

RangeSum(Above(sum({<Year_Month>}sales), 1, RowNo())) * Avg(1)

[Anonymous]

it makes it, but i when applying that expression on a butoon it gives me a 0 .

[sunny_talwar]

Expression to a button? Do you mean a text box object