Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
carlos13
Creator
Creator

Help in expression

If I can help calculate an operation, the result is having the pivot table is incorrect in an expression.

I want to make the operation A / (A + B) of expressions

Thanks,

Carlos

3 Replies
datanibbler
Champion
Champion

Hi Carlos,

that looks correct - but for the fact that it's all calculated at the same time, not sequentially, so you cannot refer to the expression in column "A" just by typing "A" - you have to actually type the expression there.

carlos13
Creator
Creator
Author

Hi DataNibbler,

What I want is to get the final result as shown in the text objects to be 45.96%

datanibbler
Champion
Champion

Hi Carlos,

I don't know what that is - the average? How is it calculated?

Anyway, you just play around a bit with the properties_dialog - "formula" tab - that box "total value" (on the right-hand side) - you have a dropdown_box there to select "xx of y_axis_values"

HTH

Best regards,

DataNibbler