Pivot table % calculation at each dimension sub total

[dusasuman]

Hi Community,

I have a small requirement that, i need to calculated the % of students based on the each group based on the total at 1st dimension level.

I have two dimensions in a pivot table..

Here i am sending the excel file of pivot table. The yellow highlighted cells are values that i am getting in  qlik.. The green cells are the expected results..

Please help me out..

[sunny_talwar]

Try this:

Count(ID)/Count(TOTAL <[JC Group#]> ID)

[MK_QSL]

Use

Count(ID)/Count(Total <[JC Group#]> ID)