RE: Reporting – MTD and YTD

Hello – wondering how to set up a column showing YTD and MTD amounts?

user62319758 Rookie Asked on August 10, 2021 in How To's.
Add Comment
1 Answers

Not much to go on here, but in your customize search button, you will have the ability to add to criteria and results.  You could add a column that includes month and a column that includes year to results.  Then add your data field with a formula referencing  the month for that line, and another column with formula referencing the ‘year’ field to sum.  Not totally sure given the lack of description if that will work for you; it sounds like what you may be looking to do is actually enable subtotals by month & year rather than another column.

The analytics tool may also be more able to let you compile the data how you’re trying to.

Rookie Answered on August 10, 2021.

Hi there – sorry for the lack of detail! I am hoping to have MTD and YTD columns on the Income Statement

on August 10, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.