Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

About "Calculated Measures"

Luciano Carvalho asked on March 15, 2018

Where do I find complete documentation on using the interface for creating “Calculated Measures” in Pivot, with examples?

3 answers

Ian Sadovy Ian Sadovy Flexmonster March 15, 2018

Hello Luciano,
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.

Luciano Carvalho March 15, 2018

Hi Ian,
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%

Tanya Gryshko Tanya Gryshko Flexmonster March 16, 2018

Hello, Luciano,
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: 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.

Please login or Register to Submit Answer