Build a chart based on different columns

[#1]

Hello Everyone,

I want to built this chart, The row level values will be changed as per the headers - TOTAL , ALM , TRADING & SCG , SALES , INVESTMENTS , INTL & OTHERS

Can anyone suggest how to build this ?

[alexandros17]

You need a pivot table, to group columns by label you need a dimension that contains the values

TOTAL , ALM , TRADING & SCG , SALES , INVESTMENTS , INTL & OTHERS

(you can do this with a load inline)

Then you must link the fields used in the columns to the field containing labels.

Let mew know

[#3]

Thanks for the response.

The row level fields NII,NFI,INVEST/CDS will be having different calculation for different headers-

For example - NII FOR ALM - NII will be based on a segment known as ALM

NII FOR TRADING & SCG - NII will be based on a segment known as Trading & SCG

How can i differentiate the values according to the Segment in one expression

[vinieme12]

can you provide a sample to demonstrate?

[#5]

Here values under TOTAL header for NII is calculated for total when Segment = TOTAL and INDICATOR = ACT

and for ALM header NII will be calculated when Segment = ALM and INDICATOR = BUD

How can i bring these 2 calculation under one expression for NII ?

[vinieme12]

can you provide sample data so people here can help you better

Preparing examples for Upload - Reduction and Data Scrambling