Pivot Table Expression - % of Sales

[#1]

I have created a Pivot Table of Sales and I am trying to convert Sales values to a % of Sales for that specific column.   See attached document.

[swuehl]

Try something like this as expression

=If( SICCodeDesc = 'EF',

     Sum(Amount), // replace Sum(Amount) here and below with your current measure

   Sum(Amount) / Sum(TOTAL<SICCodeDesc> Amount)

)

[#3]

Hi Ryan,

swuehl expression is correct,but i just add the Num format to the expression

IF(SICCodeDesc='EF',Num(Sum(Sales),'$#,##0'),

    Num(Sum(Sales)/Sum(Total<SICCodeDesc> Sales),'#,##0%'))

And leave the Number format in sense to Auto

[#4]

It worked.  Thank you for the help