fetching previous month data issuse

[#1]

Hi,

i have month n year filed the month field has apr may jun jul aug....mar

and year 2013 2014  2015

if i click year 2015 usually i get apr may jun but i need 2014 mar data to be displayed in the same way for 2014 apr....

note: i need it only for april month for all  the years in my calendar, irrespective of my month selection

[datanibbler]

Hi bhanu,

try set_analysis. Sth. like

>>> sum({1<Month = {$(=)Getfieldselections(Month)-1))}>} Sales <<<

(the parameter 1 disregards all user selections to begin with, and then you can add whatever you want, based on user_selections or not)

HTH

Best regards,

DataNibbler

[MK_QSL]

Provide your sample data file please

[#4]

sample data in the straight table i need to get the sum(labst+umlme) if the selction for 2015 year i need to get 2014 march and 2015 year apr may june data

[#5]

i have provided the sample application could you please check it and provide the details