nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Period shown module automatically update when i update the time selector

tompatrick.ting

Hello,

Is there a way I can automatically change the shown period in my module when I change the time selected?

See screenshot attached. I need to show the period in each line item.

Thanks,

Tom

Accepted answers

ChrisAHeathcote

Ok.

Then I would create a line item subset (LIS) and use this in your filter as an additional dimension.

Use a IF THEN function to determine which formula is allocated to each line item.

= IF ITEM(LIS) = LYTD ACTUAL THEN ITEM(TIME) = PERIOD(CURRENTPERIODEND()) - 12 ELSE ITEM(TIME) = PERIOD(CURRENTPERIODEND())

You will only need one line item using the above

All comments

ChrisAHeathcote

@tompatrick.ting

You can use a time system module to create a filter.

I will assume that the time period is the current period as set in the model time settings.

Therefore, create a module dimensioned only by time period month.

Create a line item called 'Current Period' and format this as a boolean.

Use the following formula = ITEM(TIME) = PERIOD(CURRENTPERIODEND())

This will check the current period as per the model time settings.

You can now use this to filter your time dimension in the target module.

Edit - I notice that you also need last year.

Create a second line item called, 'Last year.'

Use the following formula = ITEM(TIME) = PERIOD(CURRENTPERIODEND()) - 12

Create a third line item called, 'Final Filter.'

Use the following formula = Current Period OR Last Year

Use this, 'Final Filter,' in your target module.

PS. I would swap your line items and time in the pivot so that time sits above. It will present better in the resulting table.

tompatrick.ting

Hi @ChrisAHeathcote , i have done that but i still need to manually hide the other period in the module.

See below screenshots.

Thanks for helping.

Tom

ChrisAHeathcote

Ok.

Then I would create a line item subset (LIS) and use this in your filter as an additional dimension.

Use a IF THEN function to determine which formula is allocated to each line item.

= IF ITEM(LIS) = LYTD ACTUAL THEN ITEM(TIME) = PERIOD(CURRENTPERIODEND()) - 12 ELSE ITEM(TIME) = PERIOD(CURRENTPERIODEND())

You will only need one line item using the above

tompatrick.ting

Hi @ChrisAHeathcote , thanks that solution works.

In addition, is there a function I can use in the Time system module that will auto-update based on the time selector in the dashboard?

Regards,

Tom

ChrisAHeathcote

@tompatrick.ting

To synch the filter to the time selection you need to base the function on that line item.

From the screen shot I assume you have published a line item format to time period month.

Instead of referencing PERIOD(CURRENTPERIODEND()) just reference that line item.

When you select from the drop down the filter should automatically update.

Quick Links

Can you help?

Unanswered questions

Anaplan AI Actions
The July and August releases added several useful capabilities to Anaplan AI, including the ability to create and retrieve saved views and create list import actions. It would be valuable to extend these capabilities to support the full end-to-end user story: creating a saved view and using it as the source for an import…
Automatic log in AnaplanXL
Hello there, we are using AnaplanXL to pull data from 3 different sources into one Excel file. Two of them are Azure SQL data bases and the third is Anaplan itself. Whenever the Excel is opened 3 pop up windows to log in to each data base appear. Until they appear and everything is entered or clicked already 2 minutes are…
Anaplan Analyst performance on large, sparse models
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.