Last Modified Date: 25 Aug 2016
- Select Analysis > Create calculated field....
- In the Formula box, type in a formula that uses an IF statement to define a condition. For example:
IF [Region] = 'South' THEN [Sales] END
- Wrap that statement inside of an aggregation. For example:
SUM(IF [Region] = 'South' THEN [Sales] END)
- Click OK.
Additional InformationAlternate Example:
WINDOW_SUM(IF ATTR([Region]) = 'South' THEN SUM([Sales]) END)
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials