5 Replies Latest reply on Oct 25, 2016 9:27 PM by Tim Cooper

    Alternative to WINDOWSUM

    Tim Cooper

      Hi All,

       

      I have attached a packaged workbook to help with my question

       

      Simply, I would like to see the change in data from one date to the next, I have attempted this in the attached workbook.

      The difficult part that I cannot work out is that I want to see the difference regardless of the status selected on screen.. i.e I want the calculation to be made at the data level as opposed to whatever is shown on screen..

       

       

      an example:

      below we see difference between two dates

      but if I filter out the status 'A' for example, the difference in 'ORANGE' is now calculating what is on screen rather than what is within the data (I want to know difference regardless of status)

       

       

      My real world data is similar to this but has quite a lot more items and dates involved

       

      Any help appreciated! thanks