need help to develop report with column chart

32 Views

Hi

I am new to SAP BO world.Could anyone please help me to design report with column chart.Please guide me how to develop report for the following requirement.I am not aware of variance columns and variance labels.Please provide some guidance or some tutorials(for column Chart) so that I can complete the task. Please reply me as soon as possible.Waiting for reply.Thanks in advance.

Type: Column Chart

u2022 Rows: Banking Asset Margin (%)

u2022 Start / End Columns: PY YTD Act(Prior year year to date); CY YTD Act(Current year Year to date)

u2022 Variance Columns: # Var (CY-PY Act) for GOLM; Volume; Rate; Non Banking NII; Banking Volatility in NII; Banking Volatility in OOI; Fees/One Offs/Other; Volatile Items; Sophie

u2022 Sub-total columns: PY YTD Underlying; CY YTD Underlying.

u2022 Variance Labels: % Var (CY-PY Act) for Total Income and Underlying Income

u2022 Sub-Total Labels: # Var (CY-PY Act) for Net Insurance Income; Banking Volatility; Other Operating Income

Additional information

u2022 Variance columns (bar) colours: Red = Adverse to Prior Year; Green = Favourable to Prior Year

u2022 Columns to show values. Adverse values to be shown in red text in brackets. Favourable results in black text.

u2022 All values in Black, but adverse to be shown below the bar.