Last Modified Date: 30 Aug 2016
AnswerCreate a non-aggregate calculated field with a conditional test on the date for each individual measure.
For an example of a non-aggregate calculated field:
- Select Analysis > Create Calculated Field to create a calculated field.
- In the Calculated Field dialog box that opens, type a name for the field.
- Type the following into the Formula field, and then click OK: IF [Date] = 2014 THEN [Sales] END
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials