Percentag calculation based on a line

[bumin]

I have to create a table with a percentage column

the percentage in every line is calculated based on the line "revenue total" : current line / revenues total

can anyone give me a hint how to do it?

account	value	percentage
revenues dom.	100	43,48%
revenues EU	80	34,78%
revenues other	50	21,74%
revenues total	230	100,00%
HR cost	60	26,09%
material cost	40	17,39%
cost total	100	43,48%
gross margin	130	56,52%

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

If the "account" displayed above is a dimension, you might try something like the following

Sum(value) / Sum({1< account = {'revenues total'} >} TOTAL value)

Hope that helps.

EDIT: Checked syntax

[bumin]

Thanks Miguel,

works perfectly

kind regards

Bumin