Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to show my data of only 2 quarter from max date i.e if i select date 3rd april 2012 den my chart must show of data april marc feb jan dec nov what to do ??
Hi Sumita,
apply
date#(Date,'MMM-YY'')
to the date field,it will be converted from text to date
Hi,
Sum({<DateField={">=$(QuarterStart(Max(DateField),-1))<=$(Max(DateField))"},YearField=,MonthField,DayField=>} Sales)
or
Sum({<DateField={">=$(MonthStart(Max(DateField),-5))<=$(Max(DateField))"},YearField=,MonthField,DayField=>} Sales)
Celambarasan
it is showing no data to display.. y so??
actual i want to do thru variable in which user can give any date..........
Hi,
Check with this here VariableDate is your date variable but make sure it is in correct date format otherwise change it to Date(Date#(VariableDate,'DD/MM/YYYY')) here 'DD/MM/YYYY' is the entered date format.
Sum({<DateField={">=$(QuarterStart($(VariableDate),-1))<=$(VariableDate)"},YearField=,MonthField=,DayField=>} Sales)
Hi Sumita,
Please find the attached file.
Hope this will help you.
Regards,
Kushal
hi kushal,
can u please help me in that i have datefield nd date is present in MAY-10,JUN-10 like that i want to do set analysis that when i click jun 10 then it show sale of may10
my expressn is sum({$<datefield={$(=only(period)-1}>}sale)
prblm is that date in text format so it is not showng corrct output what should i do
Regards
Sumita
Hi Sumita,
Please clarify what exactly you want regarding previous 2 quarter :
If you select 01-04-2012 then you should get output as last six months from that or
if your fiscal year starts from april and your quarter 1 is april-may-jun then
previous 2 quarter will be months april may jun of 2012 and jan feb mar 0f 2012 including the quarter of the date that you have inputed.
yes exactly this i wnat in my chart current nd preceding quarter..............
bt frst plz help me
that i have datefield nd date is present in MAY-10,JUN-10 like that i want to do set analysis that when i click jun 10 then it show sale of may10
my expressn is sum({$<datefield={$(=only(period)-1}>}sale)
prblm is that date in text format so it is not showng corrct output what should i do
Hi Sumita,
apply
date#(Date,'MMM-YY'')
to the date field,it will be converted from text to date