# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Contributor

## Percentage using calculated field

Hi

I wanted to divide the Grand Total divided by Personal Total.The same has to be repeated for the remaining rows also. plz suggest?

I

17 Replies
Esteemed Contributor III

## Re: Percentage using calculated field

what do you want to show?

Contributor

## Re: Percentage using calculated field

Hi Chanty

I want the Percentage of the Pivot Grand Total(i.e 48261) divide by PERSONAL(i.e 21021) and so on....

the same concept for the remaining PERSONAL,IRA & OTHER Category.

Esteemed Contributor III

## Re: Percentage using calculated field

try this

simple way

sum(Value2)/ sum(total Value1)

Contributor

## Re: Percentage using calculated field

what is value 2 and value 1 in this case.

Esteemed Contributor III

Contributor

## Re: Percentage using calculated field

I have created the rows by using the calculated field(i.e PERSONAL,IRA,OTHER etc).So I am looking for the division between those calculated fields as I mentioned before.plz suggest

Honored Contributor II

## Re: Percentage using calculated field

Divide your expression with the same expression just adding the total identifier

Esteemed Contributor

## Re: Percentage using calculated field

It would be sum(total yourExpression) / sum( total <"Account Type..">yourExpression)

Esteemed Contributor

## Re: Percentage using calculated field

If you want it to only be diveded by the value of personal and be propaged to every single row:

sum(total yourExpression) / sum( total {<"Account Type.."={'Personal'}>}yourExpression)

Community Browser