Pivot table: how to calculate % ref other group

[mee-qlik]

In a pivot table whit 4 dimension and 1 expression ( a rangesum calc , thanks to Sunny Talvar for the help) now I have to calculate for the dimension "Conto" with ind_C_R = "C" the % vs total of group with ind_C_R ='R'

In the example , for the "CONTO" = 244 , the correct values would be abs(-111637.52 / 3431014.57) = 3.25377 ... % and so on with "CONTO" 201 ... 417

Thanks!!

[sunny_talwar · Accepted solution]

May be this

Sum({<IND_C_R={'C'}>} VALORE)/Sum(TOTAL {<IND_C_R={'R'}>} VALORE)

[mee-qlik]

Yes, correct.

My problem is al little bit complicated, I will post another example.

Thanks again!