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

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
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.…