data must show with selection for MoM

[prma7799]

Dear All,

I have one chart in that I wrote attached expression

So data is showing two year sales

My requirement is when user select financial year 2016-15

then data data will show for year 15 and 16

if user select financial year 2015-14

then data data will show for year 15 and 14 like this

(means current year and last year total 24 bars will show.)

Note: vFY=Year(addyears(max([Posting Date]),-4))

PFA..

[tresesco]

Like this?

[prma7799]

Hi tresesco‌,

Your solution is ok but I have some different requirement that

1.I want current month with previous 23 months data total 24 bars should display without any selection

2.with selection

  if suppose user select any financial year like 14-15 then also 24 bar should display but here only 21 bar present

and for 13-14 the 2015 year data also come .

See attached.

Thanks in advance

[#4]

I use set analysis to pick up last 24 month:

Sum({$<[Month]=, [Year]=, [Date]={">=$(=MonthStart(AddMonths(Max(Makedate(vYYYY, vMM)),-23)))<$(=MonthEnd(Max(Makedate(vYYYY, vMM))))"}>}  AMT)

You may try it.

[prma7799]

Hi tresesco‌,

Any help on this?

[tresesco]

Your expected output is a fair ask, but with the calendar you created is not. If you could create a sample qvw with inline data, I could help.

[#7]

Create a expression for list box such as '=(Year-1)&'-'&(Year)', and ignore other value you may add to app. Please see attached qvw.

Thanks.