topic Re: Pivot table % calculation at each dimension sub total in QlikView

Pivot table % calculation at each dimension sub total

dusasuman — Wed, 25 Nov 2020 16:16:04 GMT

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..

Re: Pivot table % calculation at each dimension sub total

sunny_talwar — Fri, 09 Sep 2016 07:47:26 GMT

Try this:

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

Re: Pivot table % calculation at each dimension sub total

MK_QSL — Fri, 09 Sep 2016 07:48:30 GMT

Use

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