7 Replies Latest reply on May 9, 2018 2:50 AM by Okechukwu Ossai

    Hide rows without loosing calculations

    gustaf.hult

      Hi all! I am a few hours into my first Tableau visualization, came pretty far before getting completely stuck

       

      Here is the thing. I have three columns of which the last is a calculated column which is accumulating values from the two previous months. I only want to show the rows for the current YearMonth meaning that I want to hide 201802 och 201803. If I do so by putting a filter on YearMonth the calculation does not include the values from these months anymore. I also tried and put a filter like LAST () = 0 but then i get only the last row (PP2 201804) and also i want to get the value PP1 201804 into the list.

       

      Due to confidentiality i can unfortunately not upload the workbook, hope this picture is enough to explain my issue.

       

      tableau.png

       

      Regards

      G