Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Oct 16, 2025, 7:46 AM

Formula/filter that brings in sales dynamically from the last 12 months (rolling 12)

I would like to know which filter or calculated field I can use to dynamically bring in sales from the last 12 months. For example, if it's October 2025, I want to see sales from September 2024 to October 2025.

Thanks.

3 answers
  1. Hideaki Shiihara (KYOCERA Communication Systems Co., Ltd.)
    Oct 16, 2025, 10:48 PM

    Hi, @Laura de Díez​ 

    It's also possible to define the most recent 12 months within the available data.

    Using an LOD function, you can determine the latest month in the dataset and include the 12 months up to and including that point.

    I hope this information is helpful.

     

    <sample>

    Hi, @Laura de Díez​ It's also possible to define the most recent 12 months within the available data. 

    <calc>

    imageimage 

     

    *If you get the best results from this exchange, I would appreciate it if you could choose the best answer or upvote.

    last 12 month c251017.twbx
Write an answer...
0/9000