How to take out the value from totals column to another cells (Pivot table )

[Kejti]

Hi All,

I'm struggling with one calculation in Pivot table. I need to calculate the multiplier to use it to have the proper numbers for Quaters 2,3,4 FY22 (please notice,for now, Category A and B has the same numbers).

The multiplier has to take the value for A or B from TOTALS 2021, by BU and be divided by the sum A+B , e.g. 

for BU: TECH and for Category: A the calculation should be: D4/(D4+D13)

for BU: TECH and for Category: B the calculation should be: D13/(D4+D13)

I did it in Qlik, but was able to do it only on the total level: 

if( (Category='A') and
((FiscalYear='FY22' and FiscalQuarter='Q2') or (FiscalYear='FY22' and FiscalQuarter='Q3') or (FiscalYear='FY22' and FiscalQuarter='Q4')),


( ((sum( TOTAL {<FiscalYear={'FY21'}, Category={'A'}>}Value))/1000000) /
((sum( TOTAL {<FiscalYear={'FY21'}, Category={'A'}>}Value) + sum( TOTAL {<FiscalYear={'FY21'}, Category={'B'} >}Value) ) /1000000)),

num(sum(Value)/1000000, '#.0000'))

But no idea how to implement it by BUs, without having as many if statements as BU do I have.

Anybody can help with this?

[Kushal_Chawda]

Please share sample app with expected output