How do I create the column set to have a column for each month and a total for the year? I want to be able to select the year and then have the columns for each month.
Trending financial report
This should do it. Create each column and then use your data Source to pick your periods for each column
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/e5aaa073-0bde-4b8d-b86f-d75ed488d8dd.png)
Then on your Total use the
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/7c3e17d4-e347-41f6-afce-0c9d59898b86.png)
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.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/d3cbeda3-656f-4910-a48c-376330888611.png)
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!
Hi,
Notice the Visible Formula. you will edit the numbers in the formula for each month:
Month 4: =iif((@EndPeriod>='04' and @StartPeriod<='05'),True,False)
Month 5: =iif((@EndPeriod>='05' and @StartPeriod<='06'),True,False)
and so on.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/ef7dcf25-0cfc-484b-a37a-81c1260dd36b.png)
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
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:
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
Yes, that is correct. I had to enter 12 different YTD columns and then it worked.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.