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.

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
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.…