Platform

 View Only

 How do you do a rolling 12 months in a report table?

Jump to  Best Answer
  • TBMStudio
Kristine Klein's profile image
Kristine Klein posted Wed February 07, 2024 04:29 PM

I would like to do a rolling 12 months in a vendor spend report that I have. I would like to see Feb 2023 to Jan 2024 for this month instead of just january. I know I have seen this in a line graph somewhere but I can't find it. 


#TBMStudio
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted Thu February 08, 2024 03:53 AM  Best Answer

I am sure you won't like the answer, as it is one I don't really like myself, @Kristine Klein, but it would work like a charm in Apptio BI:


In the Date Range option I found Last 12 Months out of the box:


(Later):

It wasn't so hard in CT, after all:

I Added Months to the Columns and then, in the Range... option:

... I selected Past Range=11, Future Range=0:


I hope this helps, @Kristine Klein.



#TBMStudio
Kristine Klein's profile image
Kristine Klein posted Thu February 08, 2024 11:46 AM

Thank you so much. That is exactly what I was looking for....And you are correct. I don't use BI as of now because my users like the filters and slicers.  We have too many entities to create individual BI reports. I create my own dashboards in CT. 

They also love the drill downs. 


#TBMStudio
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted Fri February 09, 2024 04:15 AM

I understand. I have an enhancement request to get slicers and in-table data filtering, but it gets pushed into the future. The PM people said they'd do it in 2024. Until then, Apptio BI is off the table for us too.


#TBMStudio

Related Content