Last Modified Date: 24 Mar 2018
- 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).
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.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials