filter the values in a page selector based on another page selector

Hi,

I have 2 separate hierarchies

1. L1 Region L2 Country

2. L1 Channel L2 Retailer

I have a planning module that uses both these dimensions and to plan for units sold in a country at a retailer.

I have published both the lists as page selectors on a dashboard. Currently when a user selects a country and then select a retailer they cannot see which retailers are in a specific country.

If I want to provide that functionality will I have to create a new hierarchy or is there another way to

Accepted answers

kavinkumar

@BahalR,

Here you go with more detail,

Create a Selection Module with User dimension and line items as per SS,

filter the values in a page selector based on another page selector.PNG

In planning module, create a filter line item and change the applies to and put the formula as per below pic,

filter the values in a page selector based on another page selector 1.PNG

Then apply the filter based on above created line item,

filter the values in a page selector based on another page selector 2.PNG

Publish only the selection line items to the dashboard and do your selection, now the grid will get updated based on your selection.

filter the values in a page selector based on another page selector 3.PNG

I hope this elaborates you!! Let me know if you have any doubts.

Note: You can make use of the dependent drop down, lets say if there is any relation between country and retailer then based on Country selection, My retailer selection will show only respective items. Ex below,

filter the values in a page selector based on another page selector 4.PNG

filter the values in a page selector based on another page selector 5.PNG

End result,

filter the values in a page selector based on another page selector 6.PNG

Cheers,

Kavin.

All comments

kavinkumar

HI @BahalR,

Without creating hierarchy, we can fix this. Why don't you use a line item with drop down instead of page selectors. Follow the steps below,

Step 1: Create a selection Module without any dimension (Note: If you want to make this as user specific, then put User dimension).

Step 2: Create 2 line items with country and retailer formatted.

Step 3: Create a filter line item in your planning module with respect to above selection.

Step 4: Publish only the above created selection line items to the dashboard and apply the filter on Planning module grid.

This will solve your concern. Hence based on the selections made, the grid will get updated.

Let me know if you need more clarification on this!! Glad to help you 😉

Note: You can make Retailer selection as dependent drop down, ie. Based on the country selection, you can filter out other items in Retailer selection.

I hope this helps!!

Regards,

Kavin.

BahalR

thanks for your response Kavin.

Cab you please explain Step 3 in more detail. What do you mean when you when you say create line item based in the planning module based on above selection?

kavinkumar

@BahalR,

Here you go with more detail,

Create a Selection Module with User dimension and line items as per SS,

filter the values in a page selector based on another page selector.PNG

In planning module, create a filter line item and change the applies to and put the formula as per below pic,

filter the values in a page selector based on another page selector 1.PNG

Then apply the filter based on above created line item,

filter the values in a page selector based on another page selector 2.PNG

Publish only the selection line items to the dashboard and do your selection, now the grid will get updated based on your selection.

filter the values in a page selector based on another page selector 3.PNG

I hope this elaborates you!! Let me know if you have any doubts.

filter the values in a page selector based on another page selector 4.PNG

filter the values in a page selector based on another page selector 5.PNG

End result,

filter the values in a page selector based on another page selector 6.PNG

Cheers,

Kavin.

Soumyajaiswal

@kavinkumar

Hi Kavin,

It was indeed very helpful but i am getting an error message while i am taking the two lists in Applies to for filter,

The error is: It is an invalid applies to as both the list has common ancestors.

Could you please help me understanding the error.

Regards

Soumya

kavinkumar

@Soumyajaiswal,

The above solution would work in case of the lists that don't fall into the hierarchy. In your scenario, it seems to be u trying out something within the hierarchical structure.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…