Synchronising Module Line Item with Page on same Dashboard

Hi Guys,

I have a dashboard with a grid for users to setup Promotion Entries. The module behind this grid has a numbered list called Promotions and the line items in the module are used as references in the property formulas for this List.

I have another grid in the same dashboard with the Promotions and Customer lists included. The user can input data in Periods for each Promotion and Customer combination.

My question is: Is it possible to sync the Customer in the line item of first grid with the page selector for Customer in the second grid. For example if the user selects the Promotion line item it would automatically sync with the Promotion page and customer page in the grid below. Is there any way to apply this filter selection based on the fact that the Customer is a property of each Promotion List item?

Thanks in advance,

Michael

Accepted answers

All comments

nathan_rudman

yes it, if it is the same list (which it looks like it is)
Edit the dashboard, click on the second module. Now on the left panel you should see the list of dimensions for this module. For your customer dimension, make sure "Synchronized Paging" is check and that should be it.

mmoloney

Hi Nathan,

Thanks for the reply.

The first grid has the Customer list as a list formatted line item, its not in the page selector so it won't sync that way. I was hoping that it would be possible to sync the list formatted line item with the page selector of the second grid or somehow filter the customer in the second grid which is a property of the Promotion setup grid.

chris_hall

Hi Michael

You might be able to do this if you add a filter to the second module.

If you create a new module which applies to Promotions and Customers (no time/versions) with a single boolean line item (called 'Filter?' or similar) with the formula 'Promotion Tracker.Customer = ITEM(Customer)', then use this line item as the filter on the second module does that do the trick? It doesn't synchronise the page selector, but it should limit the Customer selector to the Customer which relates to the selected Promotion.

Chris

mmoloney

Chris,

Thanks a million, that worked for me.

I hadn't thought "outside the box" in relation to using a second module as a dashboard filter but it makes perfect sense 🙂

Cheers,
Michael

RyanD

@mmoloney do you know if a similar setup could work in the NUX?

Quick Links

Can you help?

Unanswered questions

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
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…