Where do I find complete documentation on using the interface for creating “Calculated Measures” in Pivot, with examples?
Thank you for the question.
You can find documentation about Calculated Measures in the User interface section.
Please let us know if you have any further questions.
In the following situation, how to calculate the “Growth” column in Pivot:
Description 2016 2017 Growth
Blue 1000 2000 100%
Red 500 250 -50%
Yellow 500 1000 100%
Total 2000 3250 62,5%
Thank you for writing.
To calculate the “Growth” column in Pivot you need to compose corresponding formula for your calculated value, i.e drag the necessary values to formula box and add correct operators.
Here is the example on JSFiddle showing how “Growth” value can be calculated in Pivot: https://jsfiddle.net/flexmonster/znkhmye2/. Please pay attention to line 42, here is the formula for calculating “Growth”.
We recommend to add calculated values the following way:
1. compose the formulas via the user interface and add the calculated values you need
2. save the report
3. use this report later
Writing formulas manually is possible but can result in incorrect values.
Please let me know if you have other inquiries.