2 Replies Latest reply on Nov 5, 2017 10:56 PM by Prajval T

    Rolling 6 months  for each month.

    Prajval T

      Hi Team,

       

      Is there any idea how to get the summation of measures for rolling 6 months on each month.

       

      Means if have one year data like below. I need to show the latest 6 months rolling 6 months summation of data. 

       

          

      Month of Order DateProfitQuantitySales
      January₹7,140597₹43,971
      February₹1,614363₹20,301
      March₹14,752885₹58,872
      April₹933733₹36,522
      May₹6,343887₹44,261
      June₹8,223931₹52,982
      July₹6,953840₹45,264
      August₹9,041884₹63,121
      September₹10,9921,660₹87,867
      October₹9,2751,133₹77,777
      November₹9,6901,840₹1,18,448

       

      Expected rolling 6 months data for recent 6 months.

      PFA excel file, you will understand how rolling 6 months data should be calculated.

       

      In the same way i need to get the result using tableau. and then i have to calculate Ratio.

       

      Can any one please help on this....

       

      Regards,

      Prajwal

        • 1. Re: Rolling 6 months  for each month.
          Jim Dehner

          There is a table calculation that will create your rolling 6 month totals - Just apply it to the sale, quantity. and profit

           

           

          If you prefer to use a formula the formula is

           

           

          Then your ratio is

           

           

          The result is

           

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          1 of 1 people found this helpful
          • 2. Re: Rolling 6 months  for each month.
            Prajval T

            Hi Jim,

             

            Thank you so much for the reply.

             

             

            In the above post i have mention the values in the text to understand expected result.

            But i need to display only the ratio on bar Graph. I understood that you have used table windows calculations but that wil not work with bar char.

             

            for recent 6 months i need to show for every month rolling 6 moths data how i explained in the first post. 

             

            Do you have solution for this?

             

            Regards,

            Prajwal