jbrem
5 days agoNew Contributor III
CV report to show trailing 4 quarters and completed months of current quarter
My team has a requirement for a CV report to show the last 4 trailing quarters and all 3 months of the current quarter. I was able to achieve this, however when the time period is the first or second month of the quarter, I would like to show only those completed months. For example, if the period is July I would want my months columns to be June & July. Currently I am using T#Quarter(|POVTime|).MonthsInQuarter which is showing Jun-Jul-Aug. Is there any function that is able to do this? Thanks!