Pivot table columns

[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.