2 Replies Latest reply on Feb 9, 2016 11:11 PM by Larsen Rennie

    Diffrence of Sales between two or more periods

    Larsen Rennie

      Hi All

       

      I am facing one issue that we have a sales for diffrent years. I want to calculate the diffrence of sales of all the years  from the sales of  first year .For that i have used the table calculation but what table calculation it is removing sales for the first year(making it blank and rest all it is subtracting whereas i want to display the sales of the first year also. It should not disappear.

       

      In that screen shot the value for 2011 is going 0 which i dont want . Instead i want that original sales of 2011 should display .

      Is there any way we can achieve this

       

      Any body can take the superstore data and can build the logic using thatscreenshot.PNG

       

       

      Regards

      Lokender