2 Replies Latest reply on Nov 30, 2017 6:12 AM by Abhilash Sharma

    How to calculate MTD QTD YTD

    Nagaraj Ganiga

      Hi,

       

            I have a dimension called "month" which contains "Jan to Dec" and measure "Sales".

            Using that dimension I need to calculate MTD, QTD and YTD on "Sales".

       

      Example: when I select "Mar" from the dimension "month" I should get the values of only "Mar" in MTD

                                                                                                  I should get the values added from "Jan" to "Mar" in QTD since they are in 1st Quarter (Note: If that was "May" then Only for "May" since second quarter)

                                                                                          And  I Should get the values added from "Jan" to "Mar" in YTD i.e. Jan to selected month of a year.

       

          I need to use Parameter to select between MTD, QTD and YTD.

       

      How do I do that in "Tableau public 10.1".

       

       

      Thank you.