# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Pivot table percentage calculation help

Hi Experts,

In the below table

Dimension is Division

Measure is Count(distinct ID)

I have tried like Count(distinct ID)/Count(Total distinct ID) but getting wrong percentage.

1 Solution

Accepted Solutions
Honored Contributor II

## Re: Pivot table percentage calculation help

do you have Division value as null ?

if Yes you can use this expression:

Count( DISTINCT ID ) / Count( {< Division = {"*"} >} TOTAL DISTINCT ID )

2 Replies
Honored Contributor II

## Re: Pivot table percentage calculation help

what you tried seems to be right.

let's try adding Count( TOTAL DISTINCT ID ) as a new measure column to see what you get.

Honored Contributor II

## Re: Pivot table percentage calculation help

do you have Division value as null ?

if Yes you can use this expression:

Count( DISTINCT ID ) / Count( {< Division = {"*"} >} TOTAL DISTINCT ID )