# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Pivot table in Qlik Sense

Hi all,

I'm new to qlik and I'm having a little trouble with pivot tables.

I have a pivot table with Rows as School Program; dimension in columns is Month and the measure is Count(SchoolProgram)

May I know how to get these measures as percentage of month total.

Thank you.

Tags (2)
1 Solution

Accepted Solutions

## Re: Pivot table in Qlik Sense

Hi,

Try this expression for %.

Count(SchoolProgram)/Count(Total<Month> SchoolProgram)

Regards,

Kaushik Solanki

4 Replies

## Re: Pivot table in Qlik Sense

Hi,

Try this expression for %.

Count(SchoolProgram)/Count(Total<Month> SchoolProgram)

Regards,

Kaushik Solanki

Contributor

## Re: Pivot table in Qlik Sense

Thank you Kaushik.

Can you help me in generating a final column in pivot table which consists of sum of the row values and then show them as percentage of that column.

## Re: Pivot table in Qlik Sense

Sure,

Can you create a new discussion and explain with example what you want.

Regards,

Kaushik Solanki

Contributor

Surely.

Thanks