7 Replies Latest reply on Jun 5, 2013 10:46 AM by Love Tableau

    calculated field doesn't bring the data

    Love Tableau

      Friends newbie here,

       

           I have a date filter where i need to show date -1 year data. so when 06/5/2013 selected it should give 06/5/2012 sales data. I have done this but it only changes to previous date but not gives associated sales data..(gives 06/5/2013 data).

       

      EX: 06/05/2013(filter selected)

       

      Date                                                   |                 Sales                        

       

      06/05/2012(which is correct)         1000$(incorrect-shows the 06/05/2013 sales data). I need to show 06/05/2012 sales

       

      I am not sure whether i am clear. Any Q welcome.