7 Replies Latest reply: May 11, 2015 10:30 PM by Maxim Senin RSS

    what if data shift

    ria Desai

      I want to get the below data to shift to +- (1 to 5 )days through a wat if slider

       

      Date       total

      1/1/15   100

      1/2/15    35

      1/3/15     45

      1/4/15    36

      1/5/15    67

      1/6/15    37

      1/7/15     58

       

      If i move by +1 days

      OUTPUT should be

      Date       total

      1/1/15     -

      1/2/15    100

      1/3/15     35

      1/4/15    45

      1/5/15    36

      1/6/15    67

      1/7/15     37

      1/8/15   58

       

      Any approach is appreciated?

       

      I used above. But couldnt get the corner cases.

      eg: 1/8/15 58