BEX Query - Percentage Share related to other key figure sub total

[axel_]

Hello BEX Gurus,

I got the requirement to display secondary project costs as

a. % share of total costs
b. % share of primary only

I tried to use the %CT function which is working fine for the % share of total costs.
But for the % share of primary costs it is not calculated for the secondary cost elements.

There will be several projects in the report so no fixed structure -> usage of cell definitions etc.

Is there a way to calculated the % share secondary of Primary Costs for the secondary costs elements?
In Bex Query Designer?
Or in Analysis for Office Workbook (preferable without a macro)?

Thanks for all replies in advance!

Best regards,

Axel