How to show expression value in percentage?

[#1]

Hi,

I have data as below

Adam	34537468
Jack	25354223
Tony	45425324
Marbella	53445234
Kindergarten	4534523424

Dimension: Staff

Expression: Sum(Sales)

I have to show other column as Sum(Sales) in percentage in Pivot table. can anyone suggest me how to write the expression . I have tried below but not showing correct percentage

=Num(Sum(Sales)/Sum(Sales),'#,##0.00%')

Thanks.

[rubenmarin · Accepted solution]

Hi Amelia, try:

=Num(Sum(Sales)/Sum(TOTAL Sales),'#,##0.00%')

[#3]

Exactly. Thanks.

[Anonymous]

Try:

Num(Sum(Sales)/Sum(total Sales),'#,##0.00%')