1 Reply Latest reply on Jan 3, 2019 3:15 PM by Patrick Van Der Hyde

    Sum values from next months in current month

    Alejandro Delgado

      Hi Everyone!,


      I am facing a problem that I do not know how to solve in Tableau.


      I have to represent Sales (from current month or next months) VS a  monthly Target.


      When I put both measures in the graph my sales measures are distributed along all months of the year but I want to show the sum of all next month values in the current month.


      So to summarize, I want to show sales month per month and in the current month the sum of current month sales and next months sales.


      How can I achieve this?


      Thank you so much for your help!!

      Best regards