Trending financial report

This should do it. Create each column and then use your data Source to pick your periods for each column

Then on your Total use the 

This was a monthly PL and i did for a customer

Hello,

You will need 12 columns that specify Period Number, followed by a Total or a YTD Balance column. This column design is a P & L with Period balances (net change) for months 01 - 12 followed by Year to Date balance for period 12.

We can’t choose ‘just a year’; in this case we print for periods 01 to 12 or we can print for period 12 and see the same results.

This worked, other than - if I run the report as of April I was hoping that only Jan-Apr columns would be filled in and then the total for 2023 would be the first 4 months of the year but all data shows for all months.  Thoughts?  I have a 2022 column too so if I put in April it shows April 2022 YTD. 

Thank you!

This helped! Thank you! 

One more thing - my YTD column is still adding all columns (even those not visible).  How to adjust the formula to only include columns visible? 

Hello,

A YTD column will show YTD no matter what periods are visible.

Perhaps use 12 different YTD columns (Year to date with period 01, year to date with period 02, etc) with Visible formula on each one like this for period 05:  iif((@EndPeriod='05'

Laura

I had to do a calc column for each month and then was able to get it to work.

Hi @srengdahl,

Can you please elaborate on “I had to do a calc column for each month and then was able to get it to work.”

I am trying to get the total of YTD column only for the periods that are visible and not entire period from Jan to Dec.

Regards,

Raj Jasani

Hello,

I think SRengdahl used the suggestion from the previous post:

Yes, that is correct.  I had to enter 12 different YTD columns and then it worked.