17 Replies Latest reply: Oct 5, 2017 9:32 AM by surya j

# 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

• ###### Re: Percentage using calculated field

what do you want to show?

• ###### 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.

• ###### Re: Percentage using calculated field

try this

simple way

sum(Value2)/ sum(total Value1)

• ###### Re: Percentage using calculated field

what is value 2 and value 1 in this case.

• ###### 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

• ###### Re: Percentage using calculated field

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

• ###### Re: Percentage using calculated field

I have used the concept but its not working out

• ###### Re: Percentage using calculated field

A sample app would help

• ###### Re: Percentage using calculated field

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

• ###### 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)

• ###### Re: Percentage using calculated field

Can you specify the name of your dimension and your expression... also you need 21021/48261 to show up on each of the line?

• ###### Re: Percentage using calculated field

This is the condition I have given

sum(IF([PAS Ind]='Non PAS' and [Reg Cat Coarse]='PERSONAL','PERSONAL',
IF([PAS Ind]='Non PAS' and [Reg Cat Coarse]='IRA' and [Poe Cat]='RETIRE INT ROLLOVER','IRA - Internal Rollover',
IF([PAS Ind]='Non PAS' and [Reg Cat Coarse]='IRA' and [Poe Cat]<>'RETIRE INT ROLLOVER','IRA - All Other Entry Point',
IF([PAS Ind]='Non PAS' and [Reg Cat Coarse]<>'PERSONAL' and [Reg Cat Coarse]<>'IRA' and [Poe Cat]<>'RETIRE INT ROLLOVER','OTHER',
IF([PAS Ind]='PAS','Managed Accounts')

)))))
/sum(IF([PAS Ind]='Non PAS' and [Reg Cat Coarse]='PERSONAL','PERSONAL'))

• ###### Re: Percentage using calculated field

expected output?

• ###### Re: Percentage using calculated field

supposed to be a Decimal output

• ###### Re: Percentage using calculated field

Sure it will be... but where

Do you expect Total to replace 21021/48261? Or do you want to replace PERSONAL row with 21021/48261? Or do you want to create a new column where each and every row shows 21021/48261? What exactly are you looking to get

• ###### Re: Percentage using calculated field

Hi Guys,

I have got the output...I have created a new Measure field by using the same concept which has been mentioned in the above discussion its worked out...Thank u for the quick support