imterpsfan3
Programmer
Please excuse if this question has been asked before. I'm looked to do a Fiscal Year Crosstab where the Column Headers would be the Fiscal Year. How would I go about this? Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Fiscal Year Crosstab
- Thread starter imterpsfan3
- Start date
- Status
You could create a formula like:
if {table.date} in date(2005,07,01) to date(2006,06,30) then "FY 2006" else
if {table.date} in date(2004,07,01) to date(2005,06,30) then "FY 2005" else
if {table.date} in date(2003,07,01) to date(2004,06,30) then "FY 2004"
Then use this formula as your column field, substituting the dates that match your fiscal year.
-LB
if {table.date} in date(2005,07,01) to date(2006,06,30) then "FY 2006" else
if {table.date} in date(2004,07,01) to date(2005,06,30) then "FY 2005" else
if {table.date} in date(2003,07,01) to date(2004,06,30) then "FY 2004"
Then use this formula as your column field, substituting the dates that match your fiscal year.
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question