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
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
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.
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.
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,
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.
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…
