How to create custom analytical profit & loss query for current vs previous year

Hi All,

We request to make Profit and nonaccomplishment connection query with planned and actuals for the existent twelvemonth vs erstwhile year. 

And we request to person the Total Sales, Total Cost and Total Gross Profit arsenic as header rows on with the FSV hierarchy.

We person a modular cube I_ActualPlanJrnlEntryItemCube but one americium not definite however to get the erstwhile twelvemonth results. Please suggest however this tin beryllium achieved.

Below the snapshot of the YTD Profit and Loss requirement. 

Thank you,

Manoj

SAP S/4HANA Embedded Analytics #SAP Custom Analytical Queries @Masaaki @mlauber