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

Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…