I have gross sales ytd, but I need to get net sales. There can be sales that happened in prior years that cancelled this year. How can I get net. I have a Sales Date Column and a Cancel Date column.
In other words I need a way to get the following, whether an equation or creating variables/tables:
Net Sales= Count(Sales Date)- Count(Cancel Date)
YTD Net Sales As of 5/2/2017 (Only select Year 2017 Sales Date)
|Division||Sales Stage||Sale Date||Cancel Date|