6 Replies Latest reply on Jan 14, 2018 3:07 AM by Norbert Maijoor

    Fixed LoD not working with dimension filter

    siva kumar

      Hello Experts

       

      My report is not working as per expectation with tableau Order of execution flow.

       

      I am a beginner in tableau and I have dimension filter for current year but I need to total sales for previous year to compare the values for current year to previous year.

       

      For previous year I have calculated the total sales using FIXED LoD (As Fixed will execute before dimension filter)

       

      For current year I have applied dimension filter but when I add dimension filter Calculated field Fixed LoD returning NULL.

       

      I am not sure where I am doing wrong.

       

      Please help.

       

      Thanks

      Siva Kumar