5 Replies Latest reply on May 31, 2013 1:40 AM by Lucie Salwiczek

    chosen month devided by previous month

    Lucie Salwiczek

      Hi All,

       

      I am rather new to Tableau 8 and will be very grateful for some advice.

       

      One analysis sheets contains about 15 columns where various factors (e.g. number of new customers, number of orders, Sales €, etc) are analyzed on a monthly basis. OrderDate is used as a filter to actively choose the month(s) to be analyzed. I am searching for a formula that calculates (for example) the monthly sum of Sales for this chosen month divided by the monthly sum of Sales of the month previous to the chosen month (see attached excel sheet). This means, if one choses for analysis

      a)      March in the filter, then the column needs to calculate for example [Sales in March] / [Sales in February].

      However, if

      b)      the chosen month is April, then needed is [Sales in April] / [Sales in March] .

       

      Examples of desired results are provided in the attached Excel-Sheet.

       

      I found various solutions for my question, but they all specify a parameter as a quick filter (not as an ordinary Filter) and then use this parameter for calculations. What I need instead, however, is a way to use the ordinary Filter, i.e. to determine which month has been chosen to be analysed.

       

      Attached is a very simple worksheet with only one column that shows the OrderDate filter we use.

      Thank you very much for your help!