asked on October 10, 2017
Hi support, we are currently trialling the pivot grid, for an unlimited perpetual distribution, and I am looking at the end user experience. From this, I have three questions about Slice properties:
What is the intended use of the Aggregate function 'Index' and how is it calculated?
What does the Aggregate function "Difference" compare the measure to? What is the calculation for this?
Within the calculated Value window, how does the 'Calculate individual values' tickbox affect the calculated field results?
If you would prefer these questions logged individually, please let me know.
Many thanks,
Jules
⋅ October 10, 2017
Hello Julian,
Thank you for your interest in our component. You can find our answers below:
1. The Index aggregation is calculated the following way: Value = ((value in cell) x (Overall Grand Total)) / ((Grand Row Total) x (Grand Column Total))
2. The calculation of the Difference is next:
VAL | Difference(VAL)
1. 100 | -
2. 110 | 10
3. 90 | -20
4. 75 | -15
Total 375 | -
Difference(VAL)1 = empty value since there is no VAL with zero position
Difference(VAL)2 = VAL2 - VAL1
Difference(VAL)3 = VAL3 - VAL2
Difference(VAL)4 = VAL4 - VAL3
Total: no total
3. You are welcome to visit our documentation - http://www.flexmonster.com/doc/calculated-values/. All the necessary information about the individual calculations is available there.
Please let us know if you have any additional questions here.
Best Regards,
Dmytro.
