Pivot replication in PowerBI

[Yrstruly2021]

How do i recreate this Pivot chart in tab SAP source https://docs.google.com/spreadsheets/d/1gN8AGcn6glEuZU0DTvAfgcPPU1n36QY-/edit?usp=sharing&ouid=10412... From the Source Data tab?

My PBIXhttps://drive.google.com/file/d/1LP6PDoz9HtQDg5Minqnv9GJnOBauNEDq/view?usp=sharing 

[amitchandak]

@Yrstruly2021 , I doubt you can create a complex table like this. Few workarounds are

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU
Power BI How to get two columns format Profit and Loss Statement(P&L) right: https://youtu.be/WLg85yiMgHI
https://medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e...