3 Replies Latest reply on Sep 23, 2018 3:51 AM by September Clementin

    Date Compare Custom Season to date in Tableau

    Nandha Kumar Murugesan

      I have a scenario to compare the custom season to date comparison

      Let's have 2 season in a year (*1-jan-2018 to 31-may-2018) and (*1-june-2018 to 31-dec-2018)

      For example

      1)

      My selected date 13-6-2018

      then i should get the values

      STD -> Season To Date

      Sales[Current_STD] -> sum(sales) from 1-6-2018 to 13-6-2018

      Sales[Past_STD] -> sum(sales) from 1-6-2017 to 13-6-2017

      2)

      My selected date 11-3-2018

      then i should get the values

      STD -> Season To Date

      Sales[Current_STD] -> sum(sales) from 1-1-2018 to 11-3-2018

      Sales[Past_STD] -> sum(sales) from 1-1-2017 to 11-3-2017

       

      whats the best approach to get it in single sheet