7 Replies Latest reply on Jun 13, 2018 8:24 AM by Shinichiro Murakami

    How to keep count Fixed To Two Dimension for Previous Value

    susheela.hegde

      Hi All,

       

      This Discussion is continuation of below thread.  If I change the parameters, previous value should remain constant .

       

      https://community.tableau.com/thread/271097

       

       

      As Joe suggested I do get the Previous value by keeping it fixed.

      How ever, If I filter by region, then count is different.

       

      So, in this example, If i filter by Region East, Previous quantity shows 4 for 4/17/2017 where as it should be 1(worksheet-Quantity-2).

       

      My calculation should be in two steps.

       

      1. Calculation  [Prior quantity -Fixed] -  { FIXED [Order Date],[Region]:COUNTD([Quantity])}

      2.   { FIXED : COUNTD( if [Order Date] >= Dateadd( [Select Period], -1, DATETRUNC([Select Period],[Date Selection]))

      and [Order Date] <= dateadd( [Select Period], -1 , [Date Selection]) then

         [Prior quantity -Fixed] end) }

       

       

      This calculation doesnt seem to work.

      Can somebody please help me with this?