FAB / UI Grid - IR MTDC Actuals Multi Year Report Grid
This FAB /UI report defaults to a very useful multi-year historical view with MTDC Actuals for FY10, FY11, FY12 and FY13. To see your lab, division(s) or program(s), changes the DIVISION Filter under "Rows". Save and Name the Filter.
You can further refine sorting and grouping by adding account attributes to the grid - Rate Type, Facility Code, Subfacility Code. Recall these show up on the right and you can move them. Don't forget to select "View" "Save Grid Layout and Options" to keep these new columns on your grid. Recall these show up on the right and you can move them. SEE EXAMPLE BELOW
To see your group's MTDC info only for FY14, change the year from "2010;2011;2012;2013" to "2014". Save and name the new filter. SEE EXAMPLE BELOW
NCAR - To see your MTDC by Normalized Fund Source, change Fund Source from "Level 0" to "CSC, All Indirect, NSF Base, NSF_Spec and Non NSF" under "NCAR ABR" selecting each type with the ctrl key. Also UNCHECK the Include Descendants of Consolidated Members box. Save and name the new filter. SEE EXAMPLE BELOW
To see the MTDC by each Month, change from "All Months" to "October, November, December, January, February, March, April, May, June, July, August, September from under "All Months", opening each quarter to see the months listed and select the months with the ctrl key. Move the months from Alphabetical Order to FY order and save via "View" and "Save Grid Layout and Options", Save and name the new dimension filter. SEE EXAMPLE BELOW
To see the MTDC by each Quarter, change from "All Months" to "Q1, Q2, Q3, Q4" from under "All Months", select each quarter with the ctrl key. Save and name the new dimension filter. SEE EXAMPLE BELOW
To see MTDC by Running Total for each month, change "All Months" to "Oct YTD, Nov YTD, Dec YTD and so on" under "All YTD" selecting each with the ctrl key. Save and name the new filter. SEE EXAMPLE BELOW
You can further refine sorting and grouping by adding account attributes to the grid - Rate Type, Facility Code, Subfacility Code. SEE EXAMPLE BELOW
