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.

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Anaplan add-in for Power Point security issue
Hello everyone I am going through an issue with security when logging into Anaplan via power point add-in. I am a workspace administrator and SSO user. But once I installed add-in for power point, I am not able to login. I am using Universal Login (default) connection and it asks for user name and then a password (not…