Has anyone attempted to do this type of reporting? I'm a bit confused by the code. We only want Fiscal 17 which started in October. Also, I still want to have other groupings along with this particular one.
Text Mode Code
group.0.linkedname=direct group.0.namekey=plannedstartdate group.0.notime=false group.0.valueexpression=IF({plannedStartDate} < DATE("10/4/09"), "FY 2009", IF({plannedStartDate} < DATE("1/2/10"), "Q1 2010",IF({plannedStartDate} < DATE("4/3/10"), "Q2 2010", IF({plannedStartDate} < DATE("7/3/10"), "Q3 2010", IF({plannedStartDate} < DATE("10/2/10"), "Q4 2010", IF({plannedStartDate} < DATE("1/1/11"), "Q1 2011", IF({plannedStartDate} < DATE("4/2/11"), "Q2 2011", IF({plannedStartDate} < DATE("7/2/11"), "Q3 2011", IF({plannedStartDate} < DATE("10/1/11"), "Q4 2011", "FY 2012"))))))))) group.0.valueformat=atDateAsWeekString