Pivot table format

[priyarane]

Hi Experts,

Please check my screen shots.

screen1 - Right now my dashboard looks like that.

screen2 - requirement which I need to create.

like: Parent - Child-subchild

EAD

Risk Weighted Assets (Current)

Capital (Current)

Total RWA including Notionals (Current)

EAD (Current)

Credit

Market

Ops

Total

Deductions

Expected Loss

ALLL

Expected Loss - ALLL

Total   Capital

Capital Deductions Notional

EL-ALLL Shortfall Notional

Intangible Assets Notional

CRD IV Notional

Total RWA plus Notionals

CCR

NCCR

Headings(EAD,Risk Weighted Assets (Current),Capital (Current).......),subchild(CCR,NCCR) are not in my data.. so how to do it. Can some one please help me.

[john_s_w_wood]

I may need to see your example qvw but it looks like you need to have the dimension with the CCR, NCCR content in and drag it to the horizontal position (Click on the field name and drag with the mouse. It will show either a blue vertical or horizontal line to indicate whether the field will be in rows or columns)