Regarding Period Exp

[d_koti24]

Hi ,

i Have field period,

Period	sales
1/30/2015	100
2/27/2015	50
3/31/2015	500
4/25/2015	200
5/29/2015	150
6/01/2015	100
6/02/2015	015
6/05/2015	22
6/06/2015	555
6/08/2015	666
6/10/2015	777

In bar chart i want show the all month end dates with current selection period

ex:

if i select 6/08/2015 in period

i want show bar chart with these values

1/30/2015  2/27/2015  3/31/2015  4/25/2015  5/29/2015  6/08/2015

if i select 6/10/2015 in period

i want show bar chart with these values

1/30/2015  2/27/2015  3/31/2015  4/25/2015  5/29/2015  6/10/2015

how to achive this?

[Anonymous]

Take a variable:

VMaxPeriod=date(max(PeriodName),'DD/MMM/YYYY')

and then use Expression at chart level:

=sum({<PeriodName={'<=$(=VMaxPeriod)'}>}Amount)

[d_koti24]

Thanks ...!

[d_koti24]

Hi Sasi,

How to do same thing for quarter?

ex:

31/3/2015 10/06/2015

if select 08/06/2015

i want like this:

31/3/2015 08/06/2015.

regards,

koti

[sasikanth]

HI,

You can do the same with the above expression

=sum({<Period={'<=$(= MonthEnd(addmonths(max(Period),-3)))>=$(=MonthEnd(addmonths(max(Period),-4)))','$(=max(Period))' }>} sales)

[d_koti24]

Hi Sasi,

Actuvally My period field contains  10months data.

so i want latest 3 quarters last date date and current selection date.

like this :

3/30/2015 6/30/2015 9/30/2015 and current selection date 10/05/2015

How to achive this?

[sasikanth]

hi

try something like this

=sum({<Period={'=$(=quarterend(addmonths(max(Period),-3)))','=$(= quarterend(addmonths(max(Period),-6)))','=$(= quarterend(addmonths(max(Period),-9))) ','$(=max(Period))' }>} sales)

but make sure that sales are available for all quarter ending dates