topic Pivot Table Expression - % of Sales in App Development

Pivot Table Expression - % of Sales

Fri, 24 Jun 2016 23:21:04 GMT

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 — Sat, 25 Jun 2016 08:30:43 GMT

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)

)

Mon, 27 Jun 2016 01:13:41 GMT

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

Mon, 27 Jun 2016 22:23:23 GMT

It worked. Thank you for the help