for loop in variable

[santhosh_k_n]

Hi All,

Is it possible to use for loop in a variable.?

Thanks,

Santhosh

[anbu1984]

Can you elaborate more on your requirement?

[santhosh_k_n]

my requirement is to display volume for rolling 28 days in a line chart  where x-axis is days and y-axis is volume

consider table :

date	date-28	volume expression to be in chart
13/05/2014	15/04/2014	sum({<date = {>=15/04/2014,<=13/05/2014}>}quantity)
12/05/2014	14/04/2014	sum({<date = {>=14/04/2014,<=12/05/2014}>}quantity)
..
..
01/05/2014	03/04/2014	sum({<date = {>=03/04/2014,<=01/05/2014}>}quantity)

This what i required

Table represent seems easy but dynamically should display volume for last 14days

[#4]

You should create an Asof Table

See a doc I have written on that topic:

Simply create YTD, moving totals and comparisons versus Year Ago

Gysbert also explained this topic.

Fabrice