7 Replies Latest reply on Sep 21, 2016 4:34 AM by Samuel Gee

    Embarrassingly Easy Question

    Samuel Gee

      I have [Week] in my dataset as a dimension. It's an industry-standard value rather than a date, so in the format 1601, 1602, 1603 etc.

       

      I have [Sales], also.

       

      I'd just like to say show me the sales for the latest week, which will always be the highest value in the dimension.

       

      I think something like:

       

      IF [Week] = MAX[Week] THEN SUM[Sales]

       

      But I'm mixing aggregate and non-aggregate in an IF. I tried getting rid the [Week] and just saying

       

      IF MAX[Week] THEN SUM[Sales]

       

      But nada also.

       

      Any help on the calculated field text?

       

      Thank you!