Row wise percentage in pivot table

[sunitha_chellaiah]

Hi,

I want to row wise percentage in pivot table. But I am not getting the desired output.

Percentage to be shown against each branch. But here it is showing 100.0.

I have used below mentioned expression.

(sum(pm.TOTAL_BILL_AMOUNT))/(sum(TOTAL<BranchName> pm.TOTAL_BILL_AMOUNT))*100

Please give me a solution.

Thanks.

[mfchmielowski]

Hi.

Try:

(sum(pm.TOTAL_BILL_AMOUNT))/(sum(TOTAL<BranchName=> pm.TOTAL_BILL_AMOUNT))*100

Note that there is = sign after BranchName.