This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Calculate the Average for the indicator as on the pivot with the filter
To calculate the average value for the indicator and get the same result as in the Pivot, we use the simple AVG formula in both cases and get the correct result.
But if we will add a filter for the Marks, the result will be different.
To fix this, you should use a formula for the indicator widget:
avg([student],[Average mark])
where, [student] is All items and [Average mark] is average for the Mark values.
The final result will be
