Requirement:
Develop a BIP report in fusion ERP to display all month’s data in Columns (Vertical) format for the selected year in excel/rtf template. Highlight the data in different colors based on specific criteria.
Approach:
Report Layout: Develop data sets for each month in BIP Report, prepare Excel/rtf template in BI Publisher, group the data in column wise for each month and assign data sets against the group in excel/rtf template.
Highlight data with colors: To Identify the rows use Conditional formatting rules, macros and choose the colors in Excel to apply it.
Conditional Format Formula:
