Hi,
How do I show the rolling 4 quarterly periods on the table?
For example, it's currently showing Q1FY22,Q2FY22,Q3FY22,Q4FY22. Let say Q1 has ended, I would then like show the next 4 quarters, namely Q2FY22,Q3FY22,Q4FY22, Q1FY23
Hi, @DarrenS!
You need to set up a custom filter.1. You need Line Item in which you indicate the current quarter (or you can formally refer to the current period from the model calendar).2. In the system time module, count the filter on the quarters. The formula will be something like this:
ITEM(Time) > LI Current quarter AND ITEM(Time)<= LI Current quarter + LI Number of quarters to show
LI Number of quarters to show it is input LI for definitions "How many quarters what you would like to see?". And you can make this LI/Filter by users for best UX/UI.
Would you be able to show me visually? I do not quite know how to get around in doing it.
Thanks.
Here's a quick example of what this might look like. For greater flexibility, these settings are usually made in the context of versions. Also, the reporting quarter may be defined slightly differently if you use the built-in versions.
@DarrenS
You can achieve this in two ways:
Rob
Hi everyone, I'm trying to use this function on specific members of my grid, as described in the documentation. In my example, the grid contains two row elements: ACTIF and PASSIF. The problem is that when I use this function, it affects all elements in the grid, whereas I only want it to apply to the specified member:…
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
