Last Modified Date: 06 Mar 2020
- In the view, select the Percent of Total field and drag it to Measures.
- Name the field.
- Right-click the field under Measures and select Edit
- Replace TOTAL with WINDOW_SUM
- If the numbers are still incorrect, right-click the field in the view and select Compute Using > Table(down) or Table(across).
Create a Level of Detail based calculation and replace the measure in the view. The calculation for this example would look like the following:
The Count Distinct is calculated at the Region level and then the values are summed in the rows as well as the totals. For more information about Level of Detail functions, see Level of Detail.
The following is the corrected percentage distribution:
CauseNon-additive aggregate functions, such as COUNTD(), MEDIAN(), and RAWSQLAGG(), do not calculate correct totals when used with the TOTAL() table calculation function.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials