5 Replies Latest reply on Feb 17, 2017 2:56 AM by Mahfooj Khan

    How to do a rolling calculation based on month selection in filter

    Naveen AM

      Hi,

      My data contains 2 items- Revenue and Costs from Oct 2015 to Dec 2016. The user input is the month and year which can be any value between Jan 2016 and Dec 2016.

      The value to be shown is a ratio explained below:

      Lets say the user selects year as 2016 and month as Dec 2017. Then the ratio for Dec = ( Sum of cost of Dec, Nov and Oct) / (Sum of revenue of Dec, Nov and Oct). This has to be done for all months from January till the selected month, in this case December.

       

      I'm not able to figure this out at all. Workbook is attached. I'm using tableau 10.1.4