Selecting a month boolean line item then only month data should be displayed in other module

lakshmidarisi2025

in Module i need to give 3 boolean line items named year ,month, quarter. in other module i need to have a line item named order amount .

so the thing is if i select a year boolean line item in the first module then only year data should be displayed in other module where i have a order amount line item same for month and quarter .I should not use filters. Can some one suggest the approach to follow ?

Accepted answers

lakshmidarisi2025

Thanks @AjayM for the response .

All comments

AjayM

Hi @lakshmidarisi2025 ,

One statement from your question is confusing. "I should not use filters" - you can't achieve filtering without using filters. I might be wrong, so here is a solution with filtering:

1. In a user dimensioned module, create the selection lineitems

2. In the SYS time module, if you don't have already, create below set of lineitems. Bottom 3 lineitems in this snapshot are optional, and alternate way to define filters

3. Define the filtering rule in a different module with both users and time dimension. This can now be used as filtering condition for time dimension across the model, wherever you have the mentioned requirement

Note: User dimension in selection module and filtering module helps to auto-apply filtering rule for each user upon selection of month/quarter/year, without disrupting other users' views. Also, please note the summaries, as they are crucial for this logic to work as desired.

Cheers!

lakshmidarisi2025

Thanks @AjayM for the response .

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
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…