# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

## How to add sub total percentage in Qlik Sense Pivot Table

Can any one suggest how to add Percentage in Sub Total Percentage in Qlik sense Pivot Table.

Tags (4)
1 Solution

Accepted Solutions
Esteemed Contributor

## Re: How to add sub total percentage in Qlik Sense Pivot Table

I think the best you can do (without extension and without modifying the script) is this:

I created only some values to test (2 dimensions with only quantity)

Expression for % quantity is:

sum(quantity)/sum(TOTAL quantity)

10 Replies
Esteemed Contributor

## Re: How to Sub Total Percentage in Qlik Sense Pivot Table

Hi,

and try this expression:

function(field)/function(total field)

where function: is the function you want to use, example (sum, count...) and field: is your Measure field

for example:

Sum(Turnover)/Sum(total Turnover)

New Contributor II

## Re: How to add sub total percentage in Qlik Sense Pivot Table

I will works as per your logic.

I want to show in Sub Total.

It will be sown as another column.

Esteemed Contributor

## Re: How to add sub total percentage in Qlik Sense Pivot Table

sub total is displayed when your dimension is not expanded, right ?

New Contributor II

## Re: How to add sub total percentage in Qlik Sense Pivot Table

Its fully Expanded

Esteemed Contributor

## Re: How to add sub total percentage in Qlik Sense Pivot Table

can you take a screen shot of your pivot table expanded and attach it here please ?

Esteemed Contributor

## Re: How to add sub total percentage in Qlik Sense Pivot Table

Maybe he's refering to sthing like this:

sum(Measure) / sum( total <Dim> Measure)

I'll let you handle this youssefbelloum

Esteemed Contributor

## Re: How to add sub total percentage in Qlik Sense Pivot Table

as soon as I see the expected output

New Contributor II

## Re: How to add sub total percentage in Qlik Sense Pivot Table

Esteemed Contributor

## Re: How to add sub total percentage in Qlik Sense Pivot Table

sum(total <UrRegionDim> YourMeasure) / sum(total YourMeasure)