% in Pivot Table

[#1]

Hi!, I´m trying to calculate the percentile value of an variable (expense) in function of another variable (revenues) in one same dimension (count).

I have tried many different ways to solve problem, without sucess

If possible to make the percentage in function of the ID (ID=1, 500)

ID count value change% (objective)

1 revenues 500 =500/500

2 expenses 50 =50/500

[vgutkovsky]

If I understood your question correctly, this should work (where 1 is the ID of the field that you are dividing by):

Sum (value)/FieldValue('value',FieldIndex('ID',1))