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.
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)
swuehl expression is correct,but i just add the Num format to the expression
And leave the Number format in sense to Auto
It worked. Thank you for the help
Retrieving data ...