Time where a value is max

Hi, guys

What I am trying to acheive is pretty simple as in the attached file.

I would like to identify a month where "sales" is maxium among "TIME" dimension(Jan 2018 to Dec 2018)

Any pointers?

Thanks in advance

Greg

Accepted answers

On the Sales line, set the summary to MAX.

Create another module with the only List being Time, call this Time Filters with the following line items.

In the orginal module, update the Max Sales line item to be a Boolean and add this formula: Data = Data[LOOKUP: Time Filter.FY Year]

Hope this helps,

Rob

On the Sales line, set the summary to MAX.

Create another module with the only List being Time, call this Time Filters with the following line items.

In the orginal module, update the Max Sales line item to be a Boolean and add this formula: Data = Data[LOOKUP: Time Filter.FY Year]

Hope this helps,

Rob

Thank you, Rob.

Perfectly worked for me.

Cheers.

Polaris workaround for FIRSTNONBLANK
Polaris doesn't support FIRSTNONBLANK as a function parameter. I have a solution workaround for this already but not too happy with it. So wanted to know what solution workaround people have done to get around this limitation
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385