% of Total

[qlikviewaf]

Hi guys,

i have this table below - really simple.

I would like to add a column in order to have a % that is basically (Product Line Sales / TOTAL sales (HIPS+KNEE)

Which is the best syntax to do this?

Thanks!

[pedrobergo]

Hi Antonio,

Just add the TOTAL inside the SUM. So, it will be like this:

sum(Product Line Sales) / SUM(TOTAL Product Line Sales)

Pedro