Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Always want to show only last 12 months based on below expression in list box:
=Month ([GSE by KT plant.Month]) & '-' & Year ([GSE by KT plant.Month])
Please suggest ???
Thanks,
AS
create the MonthYear Field as
monthname(date#([GSE by KT plant.Month],'MM-YY')) as MonthYear.
Now using this month year you will be able to do the set analysis
Share any sample file only date field in which you have problem.
Regards
Anand
=Aggr(If(Date#(MonthYear, 'DD-YY')>=$(=Max(Date#(MonthYear, 'DD-YY'),10)), MonthYear),MonthYear)
Change the fieldname to yours.
PFA,
=Aggr(If(Date#(Month_Year, 'MMM YYYY')>=$(=Max(Date#(Month_Year, 'MMM YYYY'),10)), Month_Year),Month_Year)
Not idea why it's not working here.
Plz see the attachment.
Thanks,
AS
Aggr(if([GSE by KT plant.Month]>='$(=Max([GSE by KT plant.Month],10))', [GSE by KT plant.Month]),[GSE by KT plant.Month])
Thanks a lot