I am particularly interested in %difference, and the docs just says “Calculates the difference between two values in the row/column expressed in percentages”, but it’s not clear to me how I should specify the values that should be used. The same goes for some other aggregation functions as well.
Thank you for contacting us.
We would like to kindly provide some explanation about the way the
%difference aggregation works:
The result of such aggregation will be a percentage difference between the previous and the current value. E.g., in case your data set contains the “Month” hierarchy with two members: “April”, “February”, and the measure “Income”, the result of
%difference aggregation will be a difference between “February” income and “April” income presented as a percent. The value for the first member appearing on the grid will be empty due to the fact that it does not have any members before it.
Please check out a CodePen we have prepared for you, demonstrating the described example.
We hope it helps.