About "Calculated Measures"

Answered

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

3 answers

Public
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.
 
Regards,
Ian

Public
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%
 
Thanks
Luciano
 

Public
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: 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.
Regards,
Tanya

Please login or Register to Submit Answer