Filer Q and Year, to Calculate line items

Hi All,

My issue is that I'm using a graph to show the P&L, but my 3-year trendline is spiking, when set to Q and Years.

So I have P&L line items calculations and they are connected to different module views, so I created time filters modules to calculate the Periodic, Yearly, and Quarters.

So, if I change in the line items the summary mode to calculate yearly and quarterly values to formula, average it affects my other grids.

So is there a way I can set the quarterly view with this characteristic, the time calendar is set to 3-3-3-4

In my time module I have set a time diff line item so it can take the periods through a 3-year trend, the problem is that when I calculate Q or years the calculated number is too big because is taking for Q4 - 4 periods

So is there a way I can alter through the filters the way it calculates my data.

Thanks!

Accepted answers

All comments

anikdas

Hi @Diepcc

Can you please provide an example of the calculation that you are trying to do in monthly levels and then what is expected in quarterly/ yearly numbers?

Diepcc

Hi @anikdas

For example here I have the organic growth calculation.

As you can see my model is set to be 3-3-3-4, which is why Q4 is always bigger than next year Q1.

So my graph gets this spikes when getting to Q4

So what I'm asking for help is if there is a way to solve this, without changing all my P&L lines to, formula-average, since this impacts my periodic figures

Thanks for taking the time

Quick Links

Can you help?

Unanswered questions

Rolling forecast
Hi , I have a requirement for my stakeholder to have a medium term forecast (by month for the next 6 months) and a more detailed rolling 15-week sales forecast by day which will then feed into the wider Supply Chain planning processes over time. This needs to be updated by the Sales representants for consolidation by the…
AnaplanXL Difficulties
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…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…