Find Highest value

Options
AbhishekChatterjee14
AbhishekChatterjee14
in Modeling

How to find the highest value for the regions amongst the 3 months and show that highest value in module Test Case 2?KQ1.jpg

 

Tagged:

Best Answer

  • Kiran96
    Kiran96
    Answer ✓
    Options

    Kiran96_0-1648108067583.png

     

    Kiran96_1-1648108097745.png

     

    You can try this way to arrive at a solution

     

Answers

  • rob_marshall
    rob_marshall
    Options

    @Kiran96 

     

    While your solution works, I wouldn't advise it because you are hardcoding to a certain time member.  What happens when the model rolls to another year?  The proper solution would be to use the MAX aggregation function if you have All Periods turned on under your Time settings or TIMESUM() with the aggregation method of MAX.

     

    Rob

Categories