Filer Q and Year, to Calculate line items
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.