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.
Thank you for your interest in our component. You can find our answers below:
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.