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!