Adding calculated row in Table

[CBoardy]

Hi All,

I have a table with multiple rows including Sales and a Margin row, I want to add a calculated row which will be % of Margin/Sales. Can someone push me in the right direction, I'm not sure if this is possible or how to actually do this

Any help is much appreciated

[rui24]

Hi @CBoardy 

You can try this expression on the table adding a new measure expression

=(Margin/Sales)*100&'%'

The "*100" will transform in percentage and the "&'%' will add the symbol of percentage to the valor, if you don't want you can just use =(Margin/Sales) and in the option format number to percentage