Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
)
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
It worked. Thank you for the help