Percentage using calculated field

[Anonymous]

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

[Chanty4u]

what do you want to show?

[Anonymous]

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.

[Chanty4u]

try this

simple way

sum(Value2)/ sum(total Value1)

[Anonymous]

what is value 2 and value 1 in this case.

[Chanty4u]

is this your looking for?

Divide Field by Total of the Whole Column | Qlik Community

Column percentage over total with aggregated di... | Qlik Community

[Anonymous]

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

[giakoum]

You have been given the answer already:

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

[OmarBenSalem]

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

[OmarBenSalem]

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)