Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi DataNibbler,
What I want is to get the final result as shown in the text objects to be 45.96%
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